It's a ghost of its former self, but I'd probably still rather use Heroku today than being forced to use Lightsail even once again.
Lightsail is pretty competitive (price wise) with other providers. Been running s B2B app on it for a few years now - nothing much, just your basic crud app running on lightsail instance + lightsail db. Nice to have a "monthly" rate on each instead of the EC2 opaque (and "surprise!") pricing.
Its not my favourite, but its not terrible.
You build something, well enough that it can handle the traffic, and people come, and it does.
Welcome to the gaming industry
Yes it is, we call these dreams a nightmare
You could do this, but for the life of me I can't imagine why you do this over using a platform like DO, vultr, hetzner or any one of a hundred similar services that will give you a better developer experience for this kind of workflow, often at a fraction of the price