Google Docs is the clunky mess here and gets away with it because they nailed collaboration early and competed with an even bigger clunkier mess in Microsoft Word. Word at least is a full featured word processor, whereas Google Docs is a struggles with anything more than basic layout or formatting needs.
Notion isn’t a word processor, but unless you’re specifically trying to craft documents it doesn’t need to be. It also isn’t a spreadsheet, and you’re going to have a bad time if you try to make it act as such.
If we’re being dismissive, Google Sheets is also a poor tool for “actual data.” Modern spreadsheet usage is just a pile of inefficient hacks to operate them as pseduo-DBs. Unless you’re in the finance or accounting world, in which case you’re probably using Excel, anything else would be better served by using more powerful open-source data analysis formats and tools.
I have a million complaints about Notion, but holding up Google Workspace as the paradigm of elite enterprise product design is a joke. Get back to me when I can take the markdown produced by Gemini Canvas and paste it into Docs without issues.
For starters, Google suite offers substantial storage so you can actually use it for doing those things, even if they're not as good as you want, for far longer.
And if you do want actual enterprise tier, lots of startups and even public companies use Google suite for all their teams.