Heroku is comparable to AWS Fargate/RDS pricing in many cases, but easier to setup/understand/maintain. IMO it seems reasonably priced in a lot of situations, where we are talking about business use.
However, for personal use, if you have a few small (web)apps, it's way too expensive compared to a DigitalOcean or similar VPS.
For example, 3 applications with Postgres DBs cost 3x(7+7) = 42$/month, whereas it's entirely possibly to run this on a 5$ DO droplet.