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.

sometimes I wish there was a way to give awards to comments.