Really? How so? I have about 60GB in total stored across Google Drive, OneDrive and DropBox. Other than OneDrive requiring me to login too frequently with the desktop folder syncing app they all work identically. I've yet to have an issue with syncing with any of them after editing documents in multiple machines.
I'm not saying you're wrong I just haven't seen what you might be referring to hence why I asked.
This is going to sound stupid, but I think the major problems with Drive are the line height it uses for items within a directory and the fact that it has relatively short file pagination threshold.
I had thought that Drive was confusing, because I would "create" a Doc or a Spreadsheet in the root directory and then go back to look for it and not be able to find it. I created a Spreadsheet, and named it something starting with 'T'. This put it on the 3rd or 4th pagination request to get more files (these requests were ~1-2 seconds slow) in my root directory. But also the line height of all the files in the directory filled up so much vertical space that it felt like I was seeing most of the directory on page 1, even though it had much more content.
When I look at ~/ locally in Finder, Nautilus, etc. the line height is tight and there is no pagination. I can see everything I have access to instantly or within an immediate scroll. When I use Google Drive every file line item takes up a lot of vertical space and I have to page through results. The result is that I can't see everything and I feel as though things are missing, even though they aren't.
You are not crazy. The whole Google docs interface _is_ completely crazy. It's drives me nuts whenever I go in there and makes be frustrated because of what it could be if only they didn't have a complex about "not looking beautiful enough".
When reinstalling your system, try to install Drive into existing folder with the data. Nope, you have to choose a new folder and redownload everything[1]. While this is tolerable for small data accounts, I wouldn't trust them with couple hundred GBs.
While installing Dropbox it just syncs the difference and done.
[1]There is a workaround but you need to think about it before reinstalling the OS (saving some user data or something).
I actually like and use sheets (it's much better than Excel for simple and/or non-analytical use cases), so when I use Excel for something, it's because I want to use Excel for that thing.
I'm not saying you're wrong I just haven't seen what you might be referring to hence why I asked.