As far as warding or directly harming supernatural creatures, I’m hard pressed to think of any. As a matter of fact, I seem to recall several creatures being so fond of it that one would do just as well trying to defeat a hungry lion by tying a rib-eye to your ass and shaking it at him.
But there are several creatures whos greed can be played upon with a few nuggets whic would draw them into a trap the well intentioned hero could spring, leading to their ultimate demise.
Dragons seem to be notoriously fond of the stuff, along with other treasures, and would storm from their lair burning all kinds of thatched roof cottages and generally raising all kinds of a rukkus. Smaug from the Hobbit, although he was not intentionally drawn to a trap, was one of these ill fated lizards. I think it is a trait that tends to be more prominent in the European dragon as opposed to the Asian one.
I’ve read several references to the fact that if you snag a piece of leprachaun gold, he will be at your mercy. This generally tends to lead to all sorts of not well thought out consequences, which generally ends up with the snide little bastard skips off into the sunset with his gold back while the poor tricked peasant is stuck back where he started with a crabby old wife and a shack not fit for a third world country.
Mummies also don’t seem to be too fond of having there gold swiped, and sometimes there is a curse associated with it. You may recall fond memories of a mummy lurching after Scooby Doo grunting “Coin! Coin!” I do not recall whether or not the coin of subject was actually gold, but then again, most mummies just seem to be generally ticked off about the breaking and entering, with the gold swiping as an afterthought.
I recall reading some piece of literature once that said the Kappa of Japan had an aversion to gold. That could also have been a method of appeasement, but since I can’t find the reference, I’ll leave you with the thought.
As far as vampires go, there are so many different varieties (check Cecils article about the best methods of doing them in) that I’m sure if we dug deep enough, you’ll find some obscure blood-sucker who isn’t too fond of getting within a hundred yards of ol’ king Midas. I’ll be doing some searching after this post for you (I have quite the hefty supernatural library, and it’s going to take me awhile to wade through it)
Now, to pose a little extra question on top, I always wondered about this in a biblical sense. Gold seems to be thought of as a Heavenly metal in more than one school of thought, but in all the references I’ve read about demons, they can’t seem to get enought of the stuff. Although referencing the Lesser Keys of Solomon, now that I’m fliping through it, alot of talismanic magic seems to specifically suggest you make gold talismans and inscribe the names of angels, or several names of god and the demon can’t touch you.
Anyways, hope this helps for now. I’ll get back to you later, hopefully with some links from some of the books I find references in. But for right now, other than pissing them off, I think you’re not going to be in good shape if you threaten ol Dracula with that gold cross earing you bought in the 80’s.