Awesome Privacy has a section on note taking software:

https://github.com/pluja/awesome-privacy?tab=readme-ov-file#notes-and-tasks

Out of these I can only personally vouch for Obsidian - I've been meaning to try out Logseq as well.