I never 'got' what heroku was all about , but i have been working with linode, aws and similar for more than 10 years. I find it pretty easy to spin something up in aws
Otoh i know of a medium company (500 employees) that started in heroku and is moving to aws. Apparently they got to the top tier of the DB , and they've stumbled with several limitations by some lack of access .
Heroku is great for small teams but it's expensive. It also offered automation that wasn't easily available anywhere else 15 years ago. It's a different story in 2022.