The Intel X-25 series seem to be doing OK, but the Vertex2 and Vertex3 (brand new SandForce 2k-based drives) have really terrible failure rates. I've heard mixed things about the Crucial drives.
I am sure you guys have read Jeff Atwood's post[1] about how every SSD they've put into machines in the last year has failed. I shared that around with a group of friends scattered around Chicago and the bay area - the friend in Chicago has a company with 30 employees. They have put SSDs in 12 of the developer machines, by the end of the year 10 had failed (Vertex2 drives).
I think SSDs have a lot to offer, the performance is there for the right use-cases (which is almost every disk I/O scenario save for a few), but for a lot of folks the idea of having drives fail regularly is a suicide-inducing though (current company included).
I'm sitting on my hands for an SSD not because I don't think they are awesome, too expensive or not big enough... I'm waiting because the failure rate seems to be painfully high in these things. I want some more time in the oven before I start sticking them in my work machines.
There also seem to be other non-failure related issues as seen with the Vertex3 launch that everyone jumped on; Lookup "Windows BSOD Vertex3"[2] for a long list of issues. At least enough to make you take pause in buying one.
I have a 11 year old Fujitsu drive that is still running, an 8 year old Seagate 15k SCSI drive that is still chugging and the two SATA's in my desktop now are both 3 years old (no RAID)... I expect 5 years out of a drive at this point, turning the speed up to 11 at the expense of digging back into my workstations or servers to replace busted drives and rebuild RAID arrays... uggggg... at least for me that sounds super painful.
The only SSDs I would consider at this point if for some reason I had to get one are the Intel series, namely the 500 series. The X-25's (as mentioned) are still going strong with low failure rates and there is nothing to suggest the newer releases are any different. I'd rather see some 5-year results from those things before pulling the trigger though, which is why I haven't yet. I also haven't needed the insane speed.
[1] http://www.codinghorror.com/blog/2011/05/the-hot-crazy-solid...
[2] http://www.google.com/search?sourceid=chrome&ie=UTF-8...