I've been really diving into the Zettlekasten method because my notes are a disaster, I'm a collector of all kinds of notes, and organization of notes seems to be this illusive and fleeting thing I'm always chasing. Once I think I have a great system down, I forget about it and don't use it. D'oh! Then all the cool note taking apps distract me and now I'm working on cleaning up my mess across countless platforms so I can actually work with my notes and thoughts.
I love that you take stream of consciousness type notes as daily notes in your Notion. I do this by hand every morning as a practice called Morning Pages (from Julia Cameron's The Artist's Way) and I can't function unless I do them. They give me so much clear direction.
The question of "What would I like to produce from my notes?" is the illusive goal of actually working with my notes. The thing that has really made a difference is Obsidian. Consolidating down to Obsidian isn't exactly ideal because even though I love the way the ideas flow through Markdown, I'm not a coder, so the lack of "prettiness" is a blessing and a curse. A blessing because I don't get distracted by it (yes, they can be TOO pretty) and a curse due to the irritation of knowing I can get Obsidian to do what I want but have to go down a coding rabbit hole to figure it out.
I'm in the process of making Evernote my dumping ground to create a Digital Library with as a place to store my online research, and then taking the digital components and working with them in Obsidian so that I can turn around and create my own useful content from new connections and ideas that come through it.
It's not perfect, yet I believe we are all on the same pursuit of learning how our brains work best so we can make the most out of the potential they have.