I'm not sure this is particularly damning criticism of Notion, but rather of the cult of productivity that has taken hold of a corner of the internet over the last few years. Roam, Superhuman, Obsidian, et al, are all in this too.
I actually found Notion pretty good as a company wiki at a previous role. It has its issues, and the engineers liked it less than people in non-technical roles, but as an accessible wiki with lightweight structuring of data, it's pretty good.