I am a small fish in the big sea but I use this for my personal projects:
For small projects or Wordpress installations you can of course find a lot of very cheap or even free options as it's such a commodity by now.
Speaking more generally, it seems AWS is allergic to creating products that scale to zero nowadays.
Enterprise spend on cloud is a massive topic right now and definitely in the spotlight. A consensus is developing that the current implementation of public cloud promotes lock-in and overall much more expensive at scale.
Cloud is complex and engineers are expensive. Instead of throwing CPU cycles and disk at the problem (which is cheap compared to engineer time), we are nickel-and-dimeing everything, and changing our architectures to hack the cloud pricing models. It's pretty silly.