hi!
this is a very "it depends" question
I've found that for sites where I'm the only one working on the content, or where everyone working on the content is a developer that prefers working in Markdown, a git-based flow of storing Markdown and building the site from there tends to work well
however, if anyone working with the site isn't a developer, I prefer a headless CMS. I like Sanity and use it for several projects. I've also been impressed with Strapi, GraphCMS, and Contentful as CMS options
if the folks editing the site are not super comfortable with the web, I'm also a fan of using WordPress as a headless CMS. it's one of the better editing experiences, and when you use the API instead of its page builder it's a wonderful tool