I recommend reading this article, which is a really comprehensive resource of the state of the art:
The SSD Anthology: Understanding SSDs and New Drives from OCZ (march 18, 2009)
On page 8 there is a section "Putting Theory to Practice: Understanding the SSD Performance Degradation Problem" which is particulary interesting and important in order to understand why SSDs get slower the more you use them.
The conclusion of the author:
While personally I'm not put off by
the gradual slowdown of SSDs, I can
understand the hesitation. In the
benchmarks we've looked at today, for
the most part these drives perform
better than the fastest hard drives
even when the SSDs are well worn. But
with support for TRIM hopefully
arriving close to the release of
Windows 7, it may be very tempting to
wait. Given that the technology is
still very new, the next few revisions
to drives and controllers should hold
tremendous improvements.
Drives will get better and although
we're still looking at SSDs in their
infancy, as a boot/application drive I
still believe it's the single best
upgrade you can do to your machine
today. I've moved all of my testbeds
to SSDs as well as my personal
desktop. At least now we have two
options to choose from: the X25-M and
the Vertex.
I personally use an 128 GB SSD in my MacBook Pro. The drive is very fast, booting seems almost like waking up and last, but not least: it's silent. Although it was expensive, I would not hesitate to use the same configuration again.