SSDs in theory, are to fail after a number of read/writes however after using them for over 3-4 years, touchwood, there has been only one failure so far that was thankfuly in a RAID so nothing was lost.
I am very impressed with the SSD quality.
Can you please elaborate more about your requirements like what kind of website you have, how much traffic you receive and what is your budget? These questions can help to provide better solution to your requirements.
VPS servers with SSD drives and built on cloud platform are more in demand these days. They are proving to be more reliable and performance oriented with fast response time.