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.