I think that music has been misused at times, like a few years ago when some sites had pretty cheesy sounding MIDI files playing when you went to a site.
I think that the site for the new movie Hairspray uses "automatic" music very effectively. I guess that's no surprise, considering that it's a musical.
It takes a while to load, though.