Things are on the move, the new build of the site is coming along. I did finally settle on using Astro even though more of the shorter form posts will be server side rended (from a Turso db)
The ability to serve content via MDX files and something more dynamic like a database makes it quite flexible.
ETA: Soon-ish.