That's not my experience. I bought a 128GB Patriot Torx some time ago and one day it stopped working completely. I lost all my data. They gave me a new one and 7 months later I started having data corruption problems. Now I can't even format it from Windows.
Maybe it was bad luck twice but I'm sticking with hard drives for now.
The Intel drives are especially reliable.
http://www.anandtech.com/show/4202/the-intel-ssd-510-review/...
The typical failure mode for a hard drive is for it to work fine and then completely die. No reading or writing, just dead. Flash cells usually become "stuck" after too many writes, turning an SSD into a read-only drive. Compared to hard drives, SSDs are much more tolerant of vibration and shock. I've had several hard drives fail, but no SSDs die on me.
Most importantly, I cannot overstate the performance benefit. Any machine without an SSD feels broken to me. Considering how much time most of us spend on our computers, $300 amortized over the life of the SSD is completely worthwhile.