Wow, does this ring true for me.
I had been using Evernote for at least 7 years, then switched to Notion a few years ago, completely "reinventing my digital life" and creating my "Second Brain" with the P.A.R.A method by Tiago Forte.
I loved that for the first few months, then slowly but surely the sheer amount of interconnected nodes became... oberwhelming, to the point of me almost completely stopping to enter in new data.
I recently realized that I kind of hated my Second Brain, and did a painful migration away from it, to the stupidly simple Notes.app (the built-in Apple one).
Feels much better now: Less worrying about bloat, I deleted a bunch of stuff and do less procrastinating and fiddling about with the structure of it all.