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?