I find that as an individual (never used it within a Team), Notion is a great alternative to something like OneNote or Apple's Notes app. But the way a lot of "productivity experts" suggest using it is counter intuitive for exactly the same reasons that this person is citing. You could easily spend an hour each day fiddling with templates, filling out forms that you've created for yourself, and endlessly grooming your "backlog".

Personally I just use Notion as a dumping ground for ideas, planning stuff (like holidays), and kind of a library for stuff I may want to remember in future. If I was the kind of person that journaled it could be good for that as well I would imagine.