I just launched my most recent side project on Cloudflare pages. It's a pretty great UX. Just plug in your git repo, add your build steps, and it basically takes care of the rest: reversible production deployments - a long with unique endpoints for development branches. My project is purely static which makes it considerably easier to deploy, but I'm looking forward to trying out Cloudflare Workers the next time I have more steep requirements.

Personally I'm pretty steeped in the devops world at my day job so dealing with that as little as possible is pretty appealing to me for hobby projects.

Might be a no-go for you if Postgres is a big part of your project.