I'm a happy user of QOwnNotes and Markor with a shared dir with a sync tool of your choice. Indeed, committing my data to a closed (source) silo is what prevents me from using tools like this (Notion does look very neat).