Obsidian is honestly such a joy to write in - I use it for my blog as well:
On my end I ended up building an entire custom thing that bastardizes SvelteKit to produce a static website that I then upload to GitHub Pages, but I think over-engineering a personal website is always good fun - and hey, I can tweak lots of silly aspects like how my post names get turned into /nice-and-readable-urls.
Out of curiosity, what's the advantage of using Cloudflare Pages over GitHub Pages? Both seem to require a GitHub repository.
Github Pages also works, I used Cloudflare since almost all my other projects are hosted there + I use it to manage DNS.