> waffling about moving from Notion to something local/markdown based for a while.

Check out Tolaria [1]. Open source, works locally, uses markdown, no-databases. Git client built-in. Even has Notion-style input.

[1]: https://tolaria.md