I'm kicking the tyres on BX21 (5TB Hetzner Storage box).
Photoview, photoprism and photostructure are the apps I shortlisted.
Google photos has great UX out of the box for RAW and general photos usage, but is garbage if you have a classically organized album/folder situation.