There are a few apps in this space worth checking out

Photorprism

Photostructure

Lychee

Digikam

Synology Photos (if you have a synology)

And probably a few others I am forgetting.

https://immich.app/

https://github.com/immich-app/immich