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.

YOU JUST HOLD ON, THE STORM IS FUCKING COMING LIBS

( ITS HURRICANE SEASON AND THE STUDS IN YOUR WALLS ARE FLIMSY LET ME HELP PLEASE )