It works really well. Notion is amazing

Notion is great for individual use or small teams. But, as you suspected, it doesn't scale especially well. I have a client who tried to use it, and we had great success for a while until it quickly filled up, and the bill crept up as performance reduced. They switched to OneNote, which is better but still not a perfect solution.