Only failure I've heard of here at the office was the one in the laptop of a guy in our analytics group, and he was constantly reloading very large databases.
Most of our main production filers are now SSD as well. We have TBs of the things.
I back up to a regular hard drive (Mac OS Time Machine), but that's more simply because $$/byte is better than SSD, and performance is secondary. I would like to get rid of it, though, simply because the machine does a hard stall when the drive spins up.
At home I have 2 SSD in my machine, plus a hard drive backup. My wife's laptop is SSD, and she backs up to an SSD. Form factor wins there. It's basically a thick credit card that she plugs in every couple weeks.
Modern SSDs with modern OSes are much better at spreading the load out on the devices, giving them great working life.