I disagree in terms of my own actual usage, after the initial excitement, but that is a real danger. That said, the most beneficial usage of my notes system has been the flat "tech notes" directory of tagged files on how to do various twiddly computer things (steps and commands to "get X to work"). I used Obsidian briefly but find abandoned it for just the markdown, vim, and a helper python script to search tags.