I've been putting SSDs in all my computers for at least the past 6-7 years now and I have only had 1 failure. One of the drives I purchased recently worked for about a minute and then died. Other than that all the SSDs I've installed have worked flawlessly.
Aside from no moving parts, they are substantially faster so tend to make the computer's performance snappier. They use less power which also means less heat. Not only are they quiet, but there is no mechanical vibration either.
About the only negative to an SSD is the price since they are more expensive than a mechanical but the price continues to come down. I personally feel they are very cost competitive at this time.