> 5. Many of my current projects take the form of "big data pipeline, followed by intermittent job to rebuild a static site and push it live"; astro fits very nicely in this role

You may be interested in Observable Framework [0]

[0] https://observablehq.com/framework/