When I read people like or love Notion, I wish I could watch them use it. Obviously they are doing things very differently than I do... Typing latency while writing or editing a page is really high (bad). Every keypress you do, must be going through a long chain of "what can we interpret the user to be wanting ?" questions. Guess what!? The user is probably just trying to fucking type! Special features and options sh…
I really tried to like Notion but I found it just slowed me down -- as in actually delayed what I was doing with lag and silly things like trying to be clever as you say, not just the learning curve
I'm now trying out Obsidian(1) with a plain old directory of md files, but YMMV I never needed the table/db stuff so I dunno if Obsidian has that sort of thing or an equivalent. The directory is mounted from my NAS using its Tailscale(2) IP so it's in theory accessible everywhere, but of course I've not been able to test that much this year
e: I should note I use this for bigger notes. I use blank business cards and a pen to catch ideas, so obsidian's current lack of mobile apps wasn't an issue