I really enjoy fly.io so far and I got the impression that the primitives they have can take me really far, the only thing I'm missing is better documentation and more examples but I'm sure they will improve as usage grows. One thing that I can't wait to try is the machines api which has the ability to scale to zero.
Currently I have a directus app with sqlite and litestream on it but will probably move away from that to something custom as I don't have a good story regarding migration and ci/cd.
One downside of fly is it doesn't have direct deploy from GitHub push. You can set it up through GitHub action, but it's a lot more work than direct GitHub integration.
That's the path I took and I don't really mind using github actions but deployment is just a pain compared to other apps I built in compiled languages. (really excited to try deno in the future where I have a single bundle)
Currently I have a directus app with sqlite and litestream on it but will probably move away from that to something custom as I don't have a good story regarding migration and ci/cd.