Earlier quoted context omitted.
Google File Stream ( https://support.google.com/drive/answer/7329379?hl=en ) is the bomb - many TBs of files in it, can not even count how many and it is fast and adaptive. If you haven't tried it, you do not know what you are missing.
What's up with them? They now have three applications to do file syncing? Google Drive, Backup & Sync, and Drive File Stream? I've kept using Dropbox for all these years because they never confused people like this. There was a single app that gave you a folder that synced.
Google might drop any of their file syncing solutions, possibly even all three!