We're working on an "IDE for notes/tasks" [1] in the space of Notion and so on where you can easily self-host the sync backend with a single binary.
The idea is that you can choose between cloud or self-host (and "eject" at any time to switch between the two if you ever change your mind). We hope that might be a good balance between some companies or individuals wanting to self-host but still making it accessible when you don't know how any of that works, which indeed can get complicated fast.