I recently switched back to Obsidian (from nothing). It doesn't solve everything the way i want, but it's the closest. The biggest thing for me is it's very open to plugin development, so my goal is to heavily modify it myself (and a few community plugins) to do what i want in the short term. Saves me from forever yakshaving my home-rolled solution lol.

Also the fact that i can easily use syncing with E2E encryption (though not sure if it's been reviewed yet.. would be nice) is awesome.