* Want a web server instance that doesn't get shut down between requests? Then get at least 2 web dynos at $35/month each.
* Want to run background jobs that are longer than 30 seconds? Then get a separate worker dyno at $35/month.
* Want a database with more than 10K (!) rows? That's at least $10/month.
* Want a memcache? That's $15+/month.
And so on. For a small to medium popularity site, all of these could be combined into one VPS on traditional cloud hosting. Heroku would make sense for a startup that has plenty of cash and limited developer resources (-> buy fully-managed-everything), and knows it will need to scale to tens or hundreds of servers to handle traffic very soon. But for most hobby webapps, a single VPS somewhere else will be 10x cheaper and good enough for a long, long while.