I think the free/cheap tier is what gets people kind of hooked... it's really easy to setup something like Dokku self-hosted and run a few dozen apps on a decent rented server... Even then, there's something appealing about not having to even worry about it. Why bother setting up your own server(s) and databases when you can run in Cloudflare workers with CockroachLabs or Turso?

Even with my own server, I've explored the option(s) just to avoid potential pain down the road regarding excess load.