I seem to notice these posts every month or so and there's some new tool recommended (Foam! Roam! Obsidian! zotero!) and I'll download said tool, try it out for a few minutes and think "Hmm, ok, that might be neat" and then promptly forget about it.
Responding to your experience: I completely agree, this type of system is too detailed / intricate / involved for me to get much use out of it...I get distracted from getting anything done by all the preparation—it’s just productivity porn I use for procrastination.