From the comments I’m learning the obvious. There isn’t one approach because there isn’t one problem.
This was a success because I really understood what I was solving for.
Each scenario will change and the solution will too.
TLDR of the article; what do you want?
Don't know what the best solution is. I'm currently testing Strapi CMS on the backend with a NextJS frontend which should give me hybrid between pre-rendered/ssr as well as dynamic parts while having a consistent development experience across all of them that is very familiar to developers. Definitely not as quick to launch experience as slapping together landing pages in website builders and Wordpress with pre-made templates, but I'll see how it goes.