I've found the best note taking system that works for me is literally to store my notes in a full fledged programming language with built-in OOP support.

So for (a super simplified) example if I want to have a daily note system, I'll just define (say) a JavaScript object called DailyNotes, and everyday I'll just append some lines to my code saying, in effect, add the key for today's date to the object DailyNotes and assigns that key an array and each time I have a thought or idea I just pushes ["thought", "…"] into it.

So all of my notes comprise a huge code project.

(My actual system isn't quite like that, I use a custom syntax + language server that serves my purpose better and faster (in particular, it makes it easier to write multiline notes without need of escaping and makes it easier to default to do the literate programming style of defaulting to text))

The nice thing about it is I get to piggyback on IDE features of vscode. All the "roam-like" features are available in VSCode and implemented better (think the "peak" feature, and the wiki link feature, which can easily be simulated by using function calls! (And you can project-rename a function name at a reference just like in Roam)