@everyoneishappy thanks for sharing your concern and your questions – FYI we are about to release a new feature to enable you to manage access and create private connected accounts, which will enable you to restrict access to your Google Drive account in the same workspace as others. That should be rolling out as soon as this week – stay tuned for an announcement from us!
Notion app is a good example of how it should be setup- you still allow full read/write but choose which material this should be applied to.
I agree Notion provides nice granularity here. Google is starting to roll out similar functionality, and we’re taking a look to see how we’ll be able to support it for users as well!