Oh, I have all the thoughts about this.
I've been experimenting with this for well before Obsidian existed by using what is probably the best proto-Obsidian -- https://zim-wiki.org
And my gut is, while they can be very useful and it can be rewarding to get a good workflow for yourself, we will not see some sort of revolutionary improvement across humanity strongly attributable to these things, and I think I have a solid why we won't even if it seems like we should.
Roughly, they're attractive looking to our brains because they work just like them, nets and nodes and connections and such -- but ultimately, our brains are actually much better at that exact type of work. These tools can help, but they pale in comparison to human brains.