one note on Foam vs. Dendron .. reminds me of vim vs emacs.
One of them is simple and just gets out of your way, the other is more powerful and complex and requires more investment to set up correctly to your use case. Probably different strokes for different folks here.
I like that foam stores history in git, & can write static html output, which the project uses to self-document.
It'd be sweet to hear from folks who've tried both how they found the experience. I'll try to become one of those folks myself, at some point.
[1] https://jevakallio.github.io/notes/foam-six-months-later