How can I manage hundreds of video clips on Mac

I have hundreds of little videos of ballroom dance school figures and dance routine fragments. I had them in folders in iPhoto, then moved them to iTunes so I could view them on Apple TV. But I can't organize them into folders in iTunes. I tried organizing them simply by using a naming convention but with hundreds of clips that is unwieldy. I started looking into iMovie, but what little documentation there is assumes that you want to assemble clips into movies. I do not want to do that. I want the little videos (10-60 seconds each) to be organized so I can retrieve them by dance type (Waltz, Foxtrot, ChaCha, etc.), level (silver, bronze, gold), source (DVIDA, Fred Astaire, Arthur Murray, teacher name), and by pattern number. Is there an app that I can use that way? I want to be able to store them in organized fashion, view them on the Mac, on Apple TV (possibly with AirPlay) , and preferably also copy them onto an iPad in the same organization. I need to be able to view them without any internet connection. No iCloud, DropBox, or such. Need to store them locally on my MacBook and my iPad. Is there any app that will help with this?

An example of one of the unwieldy file names using my naming convention is: cc-ASBR-06SwivelAndHooks. This is cc for ChaCha, AS for Astaire, BR for bronze, 06 for pattern number 6 in the Astaire Bronze sequence, and SwivelAndHooks for the name of the school figure. It would be so much easier to have a file folder structure, keep a file in multiple folders (aka playlists).