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.