I’ve been very happy with logseq and use org as the file format since I also use emacs and orgmode. But having logseq being a dedicated notes solution on desktop and mobile has been great.

I know that OP isn’t interested in syncing, but another FOSS application I use in conjuction is Syncthing. I use it to sync between my devices, while still being local (to my own devices).