Don't forget that Heroku/AWS aren't immune to outages themselves. Their major outage last year (due to an AWS/EBS issue) put my app out of commission for ~16 hours (fortunately it was still in a small, private beta).
I've got 6 VPSes and 12 dedicated boxes and have never had an outage that long (self-inflicted or otherwise) in roughly 6 years. Granted, most of my dedicated boxes are managed by Rackspace and cost > $1k/month.
All that to say, I agree with your sentiments for the most part ... I just haven't seen the "prevention" of catastrophic events per say.