That's a good point, and I think in those situations the cloud will fall over just as easily. A lot of that will come down to your actual applications architecture and how well it can scale.
The idea of instant scalability is somewhat flawed. James Golick does a pretty good job of explaining why here:
http://jamesgolick.com/2010/10/27/we-are-experiencing-too-mu...
Realistically it is often very hard (impossible) to predict how viral something new is going to go. If some "superstar" grabs onto your app and publicizes it in front of 10x your normal audience, 24 hour turn around may not be fast enough.