Information/File Manager

Maybe use a file manager that supports Open Meta.

Or use symbolic links for organizing all your media files.

Or even use hardlinked files if you dare.

Depending on the number of categories you require to handle, you could always use a combination of the finder with the built in label functionality, thus a movie can be held in one area (movies directory, for example), but "tagged" as something else. Using smart directories and saved searches you can view your files by a combination of the attributes (location, label, media type) to create custom views. All without purchasing software. Cheap and cheerful, but may be suitable to your needs.

I don't use it myself, but I've heard a lot of good things about Bare Bones Software's Yojimbo

Also, note that iTunes and iPhoto cover a lot of the file types you mention (just not all in the same application).

I use Leap. A meta tag organiser, possibly the best for OS X.

Ironic Software, developer of Leap, was at the forefront of development of OpenMeta. Three owners in the Google Code area:

• ironicsu...@…
• neuma...@…
• tom.ande...@…

Mavericks Tagging In The Wild (2013-10-17) described Tom Anderson from Ironic Software as one of the creators of OpenMeta. https://de.wikipedia.org/wiki/OpenMeta describes him as a maintainer.