The big attractor to Notion for me is the All-in-on workspace idea. It's a table-database, it's a wiki, it's a kanban board, it's a team calendar, it's a project gallery, it's a blog.

Tables can have wiki notes, which can have tables. The recursive nature works very well for organizing your knowledgebase and having an entire org work together.

The things I hate about notion.

1) pressing / anywhere opens the menu. So annoying.

2) It's live collaboration on code is awful. We end up using codesandbox and then copy-pasting back.

3) It looses and new edits every now and then. Their sync needs work.

4) No way to proper version control documents and have a pull-request/suggestion like model for editing authoritative docs.

The other player in the same market is https://coda.io. They go quite a bit further than notion in terms of formulas and reference tables.

With both Coda and Notion, I feel I seldom have to use google docs.