I don't know if you've tried Obsidian, but it's just a tool that sits atop your pile 'o Markdown files. No vendor lock-in or special databases. I use Syncthing to sync the files between devices and git to periodically back them up to a private repo.
I've had to be careful to steer clear of all the plugin nonsense that's tempting to dive into as a distraction from actually using the tool, but Obsidian is surprisingly awesome right out of the box.
I use the daily note template tool to generate a structured agenda for each day, which removes the friction that used to keep me from daily journaling and second brain stuff. Now I can't live without it. It's been life-changing for me, as a person previously crippled with ADHD and perpetually living in a state of intense anxiety.
If you have any questions, I'm happy to help out. I was also an Evernote (and Joplin, and...) user for years and was never satisfied until I made a list of my requirements and discovered that Obsidian ticks all the boxes. Haven't turned back since.