I use Zim Desktop for my notes because it's simple and (precisely) because it stays the hell out of my way and lets me focus on my own writing. Over several years of doing this I've tried quite a few other tools, but none manages to hit the sweet-spot of simplicity and affordance I find in Zim. Roam, Notion and other web-based tools are just a fucking annoyance to me, being clunky to use and offering little since I have no need to access my notes across multiple devices, nor any use for publishing/"sharing" my personal notebook or pages with others. If I do want to do that I can (and do) just copy the relevant material over to my (static) blog, `git push` and the job's done.
(Edit to add: the "Backlinks" plugin is vital for using Zim for this purpose.)
Music/video is much more challenging in that regard: our computers' capabilities for searching those is pitiful, but then... keeping bookmarks to such stuff is hardly the use-case for a personal-note tool. It's for keeping your own thoughts and observations, not for bookmarking random blatherings.
I can see how someone who checks out blogs/youtube about Roam-like tools might get the wrong impression but those are usually a business so they have to output content.
It also comes down to personality, I suspect some people have a tendency to optimize tooling as a form of procrastination.
I then came to conclusion MP3 tags are harmful and removed them altogether. Because you can never tell a song genres reliably and many things can be written many different ways.
It's the same with hyper-optimized keybinding editor setups. I'd need to be able to think and type about four times faster before some of the things I've seen would make any meaningful difference.
Which is why there’s a massive industry catered towards productivity tools.
I've fond memories of hanging out in my friend's room, listening to punk while expanding our extensive Clarion MS DOS database, and then reprinting it to admire it.
At a certain point I realised I was spending more time figuring out how to tag my mp3 colletion than I was listening to music. I've been observant for similar realisations in other fields ever since.