There are two apps that potentially do some of what you want here, Yep and Leap. They certainly permit tagging of files (like the keyword feature of iPhoto). Not sure about the rest though as I haven't really used them much.
http://www.ironicsoftware.com/leap/