That said while cost limiting vps option like lightsail exists on aws, they are on the high end of cost. Sure you get a good chunk of cpu time compared to the 15$ a year vps from questionable providers, but it's hard to beat that on price, especially for single user experiments.
I wouldn't store sensitive or pii data there, but most web sites aren't a ecommerce or a social either. And while I'm a huge aws fan, my minecraft and factorio servers and openwebui deployment are on some such cheap host at a discount provider. And never went down once. Or they did but I wasn't looking, which is the same tbh for single user stuff.
It's really scummy. There's no reason not to allow me to set, eg, a 5-10x normal spend hard limit where they shut things off. For things like lambdas with accidental reflection (stop lambdaing), someone using your bandwidth to serve files (stop serving), a bug in a your Athena scripts that downloads a far broader date range than expected (stop all athena), etc.
On the other hand, doing single bare-metal boxes being much more complex and usually more expensive is a good reason to skip AWS for simple projects. In addition to the profusion of instance types and billing/usage options.
I also think the lack of options on limiting max billing for flexible services is pretty reasonable actually. For most of them, there's no single obvious reasonable thing to do when the money hits the limit. Storage costs money too, but I don't think much of anyone really wants to have their data get deleted when the cost hits the limit, for example.