Windows live image viewer gets a bit closer by letting you apply multiple tags to something, but it doesn't provide the ability to search for multiple tags. The closest thing I've seen is F-spot photo manager for Linux, but it only handles images.
OK, I've been scouring the web looking for a good multimedia manager program and everything I've tried has been disappointing.
What I want is something that will let me apply multiple tags to my files to define exactly what the image, video, or song contains. Then I want to be able to search with multiple tags to define exactly what I'm looking for. For example, I could search for images tagged funny and animals, but not cats, and the results shown would give me all the funny pictures of dogs, birds etc.
Everything I've tried so far has been lacking in one way or another. Picasa only lets you organize things into folders, and that doesn't work well if something fits into multiple categories. Windows live image viewer gets a bit closer by letting you apply multiple tags to something, but it doesn't provide the ability to search for multiple tags. The closest thing I've seen is F-spot photo manager for Linux, but it only handles images.
Is there ANYTHING out there that even comes close to what I'm looking for here? I'm really tired of having to use clunky, inefficient organization methods for my multimedia. My library is far too large for folders to be effective anymore. Over 50,000 pictures, 6,000 videos, 3000 songs...

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic