Actual UV bulbs tend to be very dim in the visible spectrum... just a dim purple, much dimmer than a standard incandescent bulb. Unless you have UV-reactive paint to show off, I'd avoid.
If you've seen a light and thought it might be UV, you probably actually saw a pink or purple bulb. I've used those in spotlights before for accent, and the have the effect you say, depending on what they're shining on. It's really easy to overdo it, however, so don't go pick up a 4SMD purple unless you want to change the color of the playfield!