For personal accounts, use Backup and Sync [1] which has selective sync, auto photos import to Google photos, and can backup the entire computer.
For corporate/G-Suite, use Drive File Stream [2] which gives fast on-demand access to personal and team drives, downloading files only when you access them.