Today we're prepping to publish our App to the iOS app-store, which will do local-wifi-photo-synching much like Google Photos, only faster (due to only transferring over local network, not the internet). It's going to be a long battle to catch up with hosted Google Products, but we're on our way.
As for Google Drive, apps like NextCloud (https://kubesail.com/template/erulabs/NextCloud) work really well, though they're not quite as slick as google products. For Google Sheets, there is https://seatable.io/.
Self-hosting software is coming along nicely. All it really needs to get as slick as Google products is more users and more money and more attention. We're hoping to provide exactly that by making it far easier to buy a "Google-Photos-replacement box" (PiBox + PhotoStructure) or a "Slack-replacement Box" (PiBox + Mattermost).