In my opinion, most sites with sound come off as being very lame or annoying. I personally find entering a site and then hearing sounds on enter very distasteful. But, if you’re able to implement sound into a site and make it so subtle that it the user browsing the site sort of expects to hear a sound, then that’s good implementation of sound.

A good example of this in my opinion would be http://www.storyville.com/.

The reason this site is so effective with using sound is the very little sound they use but the subtlety of it. For example when you hover over sections in the side menu, you get just the perfect sounding sound when hovering over. Then if you go on ahead and click on an item a box will open up, within this box if you click on items that will change the content inside you’ll get a nice transitioning sound in between content changes.

Those are just a few example from the site, there are more sounds throughout the site if you go further onto explore.