TMSU is a tool for tagging your files 12 years ago
Throwaway, but I've used it to organize downloaded porn. Downloaded videos tend to have terrible filenames, but reasonable titles or tags on the website. I have some scripts to scan through the filenames and automatically apply tags, but for the most part it still goes unused. It's a fun idea though.