This specific alarm sound...

http://www.youtube.com/watch?v=FoX7vd30zq8

...spoils and takes me out of any movie or videogame it's in.

I worked really long nightshifts for a few years so I needed something loud and unpleasant on my iPhone to wake me up and make me go switch it off (Setting nice sounds only meant I'd sleep through them). The iPhone uses that exact sound ^, it was only later that I discovered that a few movies also used that sound and I'd developed a 'Pavlov's Dog' like response to it... of feeling almost physically sick at the dread of getting up and going to work exhausted.

An entire level of Wolfenstein on the PS3 (Which I had been enjoying) has that alarm on full blast all the way through. I eventually had to play that level with the sound off so I could get on to the rest of the game LOL