I don't see the need for more than a RAID 1 (unless you need the capacity) with SSDs. They are already so damn fast compared to HDDs. Also, things like SSD caches are becoming more popular for people who don't want to take full step to SSDs. Also if you think about it. You really only need the database on SSDs. (And as far as I know, even physicians practicing for 10 years don't have DBs larger than 200 MB.)
These SSDs you see failing usually have nothing to do with write endurance but instead of the quality of the parts that go inside it.
Write endurance isn't a real issue for our databases who barely see any action. Those eMLC and SLC SSDs are targeted for those people who write large amounts of data per day (I'm talking on the order of hundreds of GB/day).