I love the idea of statically generated sites, I just want a nice to use CMS for authoring content that goes along well with the static site generator.
I'm using a SSG for my personal website, where it's no problem for me to manually write markdown files and run a command to build and deploy, but this will not work for sites I'm making for and/or with other non-technical people.
In those cases I'll have to set up some headless CMS, like Netlify CMS (now Decap), Strapi, Directus etc.
This means I have to additionally deploy the CMS somewhere (even Netlify CMS, now Decap requires an authentication backend), maybe manage some database – Then because content changes from the CMS need to trigger a site rebuild I need to set that up, use something like Netlify or Vercel or GitHub actions to build and deploy the site, trigger builds with webhooks or via git, or put together some build system myself, it's just a really annoying amount of complexity just to get a simple static site that people can contribute content to in an easy way.
My absolute dream would be an affordable (like managed Wordpress) CMS solution that allows content authoring for non-technical people with a nice UI but then also takes care of building a static site from a connected git repo on every content change and deploys it to some global CDN, similar to Netlify.
So I can build my website in Astro/11ty/Hugo/Jekyll or whatever static site generator technology I want but still make it easy to collaborate on content.
Netlify was really close to making this possible but unfortunately they didn't seem interested in maintaining / improving it, probably since it isn't really an "enterprise" kind of problem.