For this you avoid AWS, Azure and GCP. Their pricing is simply not competitive. We operate root servers at Hetzner serving dynamic content to six-figure audiences.
PostgreSQL and Elasticsearch clusters can be operated at a fraction of the cost of comparable managed services offered by the major cloud providers.
The idea that this necessarily involves excessive maintenance effort is nonsense.
The skills needed to use hyperscalers properly are better invested in fundamental sysadmin know-how.