So Heroku is good for higher margin sites. You couldn't run Facebook, because the value of each customer is marginal, and they are expensive customers.
You could host a B2B app no problem, because they are paying (high margin) customers, and will probably not use too many resources.
There are a ton of real sites that never see more than a couple hundred thousand visitors a month. E-commerce sites, mobile APIs, SAAS apps, etc. I've used Heroku for higher traffic sites than this without any issues at all. Incredibly easy actually.
Saying it's only good for your hipster blog? C'mon man really? Have you even done anything commercial / critical on their platform?