I'd say architect your solution for failure. If you design for cloud then you know you have to design for failure because it is a fact of life.

SSDs are good for random reads/writes and here they offer massive performance advantages. For sequential reads/writes the advantage is still there but it isn't at such an order of magnitude. I'm not sure the answer is SSD now what's the question?

If SSDs were a car they would be a Ferrari. Fast, sleek and sexy but ultimately not much use for carting about masses of stuff and you have to expect to burn out tyres, clutch and brakes more often than you would with a Ford.