Honestly, I know it's not cool, but OneDrive is my go to here. Syncs Photos to my server, which then copies them to a local (non cloud syncing) folder, which is then indexed with Picasa.
Works a treat and requires zero intervention, although is based on a) MS software and b) deprecated Google software, so may not work forever.
I actually don't mind OneDrive - its decent enough, and i already pay a small monthly family subscription (because partner and offspring prefer MS Office - bleh). But, the hard block is that all of my daily driver machines are linux, and there is no native, MS-supported onedrive client for linux. (Yes, i know there are a couple of popular onedrive clients, but no thanks.) So, you know what i did a few years ago? I setup Nextcloud...then tested things out, and it worked great! So, now i have no desire to ever use onedrive on linux, thanks to NextCloud! But, i don't expect others to follow me along.
Works a treat and requires zero intervention, although is based on a) MS software and b) deprecated Google software, so may not work forever.