After reading some of the comments here I decided to give the Google Backup & Sync client another go on my MacBook Pro. The CPU fan has been blowing at full speed for the last 15 minutes. It's still terrible, extremely resource-hungry and slow.