I typically don't use it, but if I pick up some latin gigs, or some New Orleans/Second Line type gigs, I'll use one. Also, a bunch of cabaret and burlesque gigs that I've gotten require things like cow bell for corny sound effects.
They are a great accessory to sprinkle in, but they go from pleasantly accenting a song to becoming hokey and awful in a split second.