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.