Off-topic: Is there a Google Photos like app out there for Android that can use a custom backend like Hetzner? By Google Photos, I mean ability to share photos with family, tag faces and have some level of smart categorization.
UPDATE: Somebody mentioned they're using "Seafile" in the comments and it seems to support Android and network drives - https://www.seafile.com/en/features/ . For tagging and categorization, try digiKam.
I don't know if there's an all-in-one solution.
Perhaps use NextCloud (self-hosted or managed) for sharing.
digiKam can detect and tag faces, and connect to NextCloud or network-mounted drives.
But digiKam's a desktop app without an Android port AFAIK.
I switched to photoprism a while ago, after having been a long time digikam user. Not being web based was becoming more and more of an annoyance. Heck, even using it on more than one PC with a shared db was a hassle.
Photoprism definitely isn't there yet feature-wise, its facial recognition is sub-par compared to digikam, it's sometimes sluggish for one reason or another, but generally speaking I like the vision and where it's going. I'm sponsoring the project, as it's basically a one-man- (and one woman) show and they like to make it their full time jobs. I like the idea, although it's still a relatively rare thing in the open source world. Currently they seem somewhat overehelmed though.
This is the first I've seen of their storage box offering: it seems like this is just a storage offering, right? Like, it can't run arbitrary software, right?
If I remember correctly, nextcloud android client has automatic gallery sync support. It also has an option to mount secondary storage device which supports SFTP, webdav, S3, openstack, etc.