After fighting Headless CMS solutions for years I ended up with using Craft in headless mode with GraphQL. It solves pretty much everything a web CMS should do and I'm able to use modern frontends like Next.js. It's the ultimate no-code solution, and you don't need to touch PHP unless you want to create a plugin.

I also like how I can host it myself locally and on the server of my choice. Throw it on a Hetzner cloud instance and get 20 000GB bandwidth each month and unlimited requests. Store the assets on S3 with Cloudfront, without any third plugins, and pay pennies. Invite as many users you want with no extra cost. Having the ability to watch the logs is also a huge benefit over Headless SaaS CMSes. No more request spikes without knowing what I did wrong.