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.

haven’t heard that name since I was 11 years old in the back of a Dave & Busters