I recently moved to doing more with Nexctloud to minimize the number of services I run, so I’m using Nextcloud Memories to manage my photos and videos. Had some issues with dates and times of old media getting messed up during my initial import but after sorting that it’s been excellent

Photoprism is great, the web UI works really well and it does a good job sorting and grouping photos based on faces / metadata.

Immich in docker, accessed with Wire guard on my phone through the Immich app.

Its not 'stable' in that it occasionally has breaking changes with updates that need you to change a line or two in the compose file, but the experience itself has been flawless. Thr stable update is planned for early next year.

It is still missing a few core features like "private" albums that won't show in your timeline/search, etc. But thats on the roadmap for the end of this year/early next also.

You can use it as a full photo managet where it does everything for you like file naming/structure, or import your files as an external library if you have a more specific setup you want to keep.

It also has stuff like facial recognition for finding certain people.

The devs are super helpful if you have questions or problems but they rely heavily in Discord unfortunately.

It's the closest to a Google photos experience and has tools to import all your photos from services like that too.

You can als look into Ente if you want to pay for hosting and dont want to selfhost. Its possible to self host, but a way bigger pain.