I've been self-hosting Standard Notes for a while, and if you think it's something you can pull off, I'd recommend it. Especially if you can get by without folders, (too many) fancy editors, or some of the extra cloud stuff they have been offering.
If you don't feel like self-hosting, there are other options too, like
The non-self-hostable but E2EE-encrypted and open-source Notesnook
The closed source but extensible Obsidian, which doesn't seem very interested in locking you into any tying
The somewhat clunky but powerful and open-source Joplin