CarotDAV is a Simple WebDAV / FTP / SkyDrive / DropBox / GoogleDrive / Box / SugarSync client for Windows OS, available free of charge. It is also able to read GoogleDocs or IMAP.
With Drive File Stream, you stream your Drive files directly from the cloud to your Mac or PC, freeing up disk space and network bandwidth. Because Drive files are stored in the cloud, any changes you or your collaborators make are automatically updated everywhere.
This doesn't exist as a separate product any longer and just became Google Drive by the looks of it.
Gladinet Cloud Desktop mounts cloud storage to your local desktop PC. It is a simple desktop application.
Remote Access to Windows File Share without VPN, syncing or migrating data in a public cloud.