The biggest flaw in SSDs as far as I know has actually been controller reliability - especially the JMicron controllers which were common prior to the recent Sandforce controllers being released. It seems the Sandforce controllers are holding up better, but still not the best (higher-than-HDD rates of DOAs, etc.). This is my own ancedotal hearsay, though, haven't really researched it.

As far as write-erase cycle limitations, here are a couple useful things:

WD white paper on NAND flash in SSD applications: http://www.wdc.com/WDProducts/SSD/wh...ution_0812.pdf
Article I found with some easier-to-digest information than the white paper: http://www.storagesearch.com/ssdmyths-endurance.html

There are other similar articles but they're nothing more than dumbed-down versions of the above.

While MLC NAND flash chips have been improving, the typical quote I've heard for endurance is 10,000 write-erase cycles per block minimum (~5% or less, usually less, of all blocks failing this early, so not a major concern), 100,000 typical (~95% or more of all blocks lasting this long), and going up from there. I've heard some claiming write limits in the millions - but I'm not so sure for MLC-based SSDs that this is true. It's certainly possible that SLC has achieved that, but no consumer-grade SSD uses SLC flash. Perhaps these higher numbers have been achieved in enterprise-grade SSDs, but I'm concerned only with consumer-grade.

In any case, if you take the data used in the article above for constant-write testing, and extrapolate it to fit a modern Sandforce-based SSD, you end up with an approximate lifetime of 1.5 years for a 120GB SSD - with the drive being written continuously at maximum throughput. This will never, ever happen in a consumer environment - it would rarely even happen in a corporate or educational environment.

Even with heavy usage, in a consumer environment an SSD will last for 5-10 years easily before it begins to fail from write-erase cycle limitations. It's far more likely that your controller will go bad before the actual flash chips do - and for all the talk of HDDs having infinite write-erase cycles, they sure as hell have a finite number of move-the-stupid-ass-mechanical-arm cycles, as I've experienced many times.

In short, write-erase cycle limits are not a reason to avoid SSDs, and regardless of what drive solution you use, you should always have an external back up of your data if you care about it.

Oh, and don't browse Wikipedia for serious research... lol, though I'm a bit confused how you got those doomsday ideas from the Wiki article, you'll notice the article I referenced above is also referenced in the Wiki (citation #52).