SSDs are more problematic than just about every other piece of hardware. It's like a Jenga puzzle, you remove one block and something else goes wrong. Just look at the Solid 3 and Agility 3. Identical hardware, different performance due to firmware.
That said, I believe that each SSD manufacturer is experiencing their own unique issues. I personally haven't experienced any BSOD issues in the lab. As an example, our workstations are allowed to sleep, which has been a cited issue with the new OCZ SSDs. Anand has the same experience - no BSOD errors in his lab. That's a similar sentiment shared by other reviewers.
Overall, SSDs are kind of like cars. You may experience something on the road, but once you bring it to your mechanic, nothing seems wrong. Problems with SSDs are highly correlated with configuration and how they are used (what is written, how fast it is written, how much is written, etc...). And I'd go so far as to chalk 99% of the "soft errors" to be related to the flash translational layer (FTL).
If you're looking for rock solid reliability, you're better off with a hard drive. It doesn't matter if you own a hard drive or a SSD, everyone should practice good backup practices.
Cheers,
Andrew Ku
Tomshardware.com