I spent the morning experimenting with various popular self-hosted task management and Notion-like applications, but none were very good.

Not terrible applications, but also not any better than what you could do either using plain-text applications like Obsidian with plug-ins, or even Emacs.