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.