It can be a lot of work. It can be a trap. But I don't think Notion is the problem.
I will share some personal experience on this journey.
I like to be organized where I need to. I worked up a TODO list habit and a note taking habit over time. At first it was pen and paper. Then plain text notes. Then Evernote. And now it's Notion.
Regardless of the tool, there were times when I overdid it. I became too meticulous. The TODO list, instead of keeping me organized and my mind free, became the source of my work and worry.
I iterated over time, and have built up a system that works for me. Whenever I feel that something becomes too heavy, I trim it. Notion is nice because it allows me to be flexible. It's more like a notebook with superpowers than Jira and Asana.
If you're obsessive and don't catch yourself, Notion can become the source of troubles. But so can cataloging your CD collection.
I recently shared my TODO list workflow with someone. I have a daily and weekly template and they're quite involved. The person was surprised asked me if I ever get stressed if I don't do it all. Not at all, I said. What I don't do gets thrown away and I start over tomorrow. It keeps me structured and organized, but I am not its slave.
It's not how involved your system is. It's how much it works for you, vs working against you.