Earlier quoted context omitted.
IMO notion is not a short-form note taking app, and I think it's not ever going to the right app for that use case (though I know lots use it that way anyway). I personally use Keep for most "notes" and notion for "documents". Some of the documents are notes but they're long-form research / project documents.
again, you can do both of these in vim/Joplin/Obsidian/Google Docs or probably a hundred other tools.
Whenever you find the data that you're entering is more relational than you originally imagined it'd be, just change it into a Table. Easy.
Got more random thoughts to add to a table item? No problemo, just open the item and you have a full-blown page to work with (which you can even nest another table inside of).
Some random item that you should really follow-up on next Tuesday? Just add a reminder.
Somehow that just resonates with the way my non-typical (adhd) brain works, and it's what's keeping me with Notion for my personal stuff despite its frustrating slowness and many other flaws.