I have around 5 year of experience self hosting.

There are tons of photo and video alternatives.

One of the first was piwigo, but I don't know what they are up to now. Photoprism brought a bunch of new interest into the space, but is a bit hindered by their pricing model.

The three frontrunners nowadays are: Immich, Photoprism, and Ente.

Immich: easy and very practical google photos recreation (and surpassing in some ways)

Ente: A self-hosted or externally hosted, easy version. More of an ecosystem with Ente Auth authenticator app like Aegis with cloud sync.

Photoprism: much more geared to photographers, tons of organizational and sorting tools and geared towards using metadata of different cameras and such. Limited for me as they don't have multi-user support unless you pay 6€/month. I would consider that an essential feature to put in their 2€/month and move advanced geocoding to 6€/month.

Immich on the other hand has a 1 time optional (you really should) $100 fee or $25 per account

They are 3 great options.