Apple’s very impressive-looking Aperture has a keyword palette that could be adapted to the Finder.

I posted mockups showing how keywords could be displayed in the Finder a while ago.