Personally, although I am relatively hardcore on privacy, I go with Google Photos on an anonymous account (I know that since it's Google, nothing is truly anonymous, but from the steps I've taken hopefully it's a bit more sanitized) because their AI can filter and organize my photos is ways that I simply don't have the time to do.
We don't need more half-attempts.
PhotoStructure already has the best metadata inference and asset de-duplicating system that I'm aware of.
It scales to millions of asset files, works cross-platform, handles JPG, RAW, and transcodes videos to web-browsable formats automatically.
I haven't used an open-source project yet that didn't fall over after the first several thousand imports, and none de-dupe (not just the same SHA, mind you, but the semantically equivalent image, based on both metadata and rotation-invariant image content). They also tend to be abandoned when the original author moves on due personal reasons, toxic comments, or the "v2 rewrite" effort collapses under it's own weight.
So, I am still taking photographs, but have no desire to share them with others and get into the inevitable competitive desire to get 'best picture'. My 600k views and several Flickr explores (several years ago) have cured me of that itch.