A few points
We've been selling htese for a while now, especially on our Video editing suits. I resisted SSD for a long time as we've had run ins with the early IDE/CF ones and PC/104 drives before, not really that fast and last months under moderate use even with logging etc disabled. MTBF was too low as was overall life expectancy.
We push out a fair number now and have done for over 18 month, we've had one failure of a cheapie Team drive that even Team were at a loss to explain (decided it just wanted to be a 1Gb drive rather than 120). And maybe a handful of controlled failures on our test rigs. So...
Failures dont seem to be any worse in terms of numbers than hard disks. Correcting for skew as we push out more HDs, they are on a par, if not more reliable than 2.5" drives (they do fail more often than 3.5"s in our experience)
Failure modes are identical to HDs, these drives support SMART (not sure why people think they dont) and will give warning of an impending failure. Block remapping does the same as bad block reallocation on an physical disk so the warnings are there. The higher end drives will also fail read only long before they die totally. We've nuked a total of one test drive and that was days old (Bad drive to start). Yes they dont clunk, click screech and wirr, but if its doing that it was too late anyway.
If you are putting all your eggs in one basket, then you'll loose data, in this respect thats poor planning and the same as a hard drive. Using an SSD makes you no more or less of an idiot if you dont backup.
Some things will prematureley age a drive, using them as swap, cache or log drives would be the biggest culprits, read life wise they should well outlast any mechanical disk. We can kill an SSD in about 3 days, I've managed to nuke hard drives in under a day with one Samsung making its heads cease to exist and a Hitachi shattering a platter.
Cloud storage is great, until you need it. So your server is backed up to the cloud ok, cool. So your office burns down, how long is that rebuild going to take in real terms? Assuming you cant get help and have to wait for a new broadband connection thats a long wait, if you can get help a few 100Gb is going to take forever. A real backup? I'll have your server back in an hour or two at most. The cloud is still an answer looking for a question and a good place to store all your cat pics. Its not a business grade backup solution and wont be while most users connect to it by 'broadband over damp string' (tm)
Our standard setup in the editing systems is a properly sized SSD with NTFS junctions used to bring all the data to where Windows expects this. On top of this the SSD is imaged to a seperate partition on the hard drive every few days meaning that in the even of an SSD failure, the user gets told 'use F10, boot from the hard disk and we'll have another SSD out in a day' We knoe this system works, its just never been tested as one has never copped out. The Team unit was an Asterisk box that freaked.