We are actually migrating away from Dropbox towards Google Drive. As we have Google NFP, the cost is nada and, imho, it provides better controls than Dropbox does.
I’ve looked at the Team Drives but am leaning against using them…mainly because there doesn’t seem to be a way to create a super view, like a file server. e.g., its great to have a team drive for finance - but I want other folks to be able to see this folder and access common files, just not be able to access sensitive files. Sure, I could share a folder within the team folder, but…
I’ve setup a single account which acts as the “file server” account, the idea being that everyone places their files there and since it isn’t actually under their account, the data can be managed centrally.
We’ll see if it works.
I’ve also looked at O365 in the past. I have used OneDrive quite extensively personally but there has been a major feature missing which forced me away from it for church use - namely its lack of support for file versioning of non-Microsoft Office files. I did see recently that they are finally (its been years!) adding versioning support for these files, but I believe it is still a bit into the future…and still can’t match the price of Google Drive.