Is there a list of Google Drive compatibility issues?
I emailed Google and got a few clues from them:


Google does not track software incompatibilities, so there is no way to know if TotalFinder is responsible for the random " (1)" file duplications. I suspect it's not. 
Google Drive does not support resource forks or aliases. Dropbox has the same limitation, but it does not destroy the files like Google Drive does.


I have briefly documented the issues here.

My final word is that Dropbox is safer to use than Google Drive, and that both are limited in such a way that they cannot act as perfect substitutes to external hard drive backups.