This might not be exactly what you’re looking for, but there is a self-hostable image booru available on the flatpak repository called Hydrus. It’s essentially just a front end for a database you can run locally on your computer and organize images/videos by category. Add tags etc.

I see. It’s all coming back to me now… Said the blind man. to his deaf son. pissing in the wind.