Cloud sync with google drive is deeply broken

So I have RB 6.8.2 running cloud sync with Google drive on Windows 10 and it is disgustingly bad.

I literally have tracks missing every time I reopen the application, the tracks have been uploaded to the cloud and done, then half a dozen will show as not available. On top of that if I try to download them from the cloud that's not possible. Even better once the collection has been synced to the cloud there is no way to take it back to a local instance without losing everything and starting from scratch. If I could use Pioneer DJ gear without rekordbox I really would because rekordbox is currently and very seriously preventing me from doing my job.
I am paying hundreds of dollars for unusable software.