Of all of the "things just went wrong" sounds, the one that gets me is the After Effects error sheep sound. Mainly because I'm usually in an edit session, and the sound tends to be turned up when this happens.
Haha. I work at a VFX studio and it used to be that the AE rendering machine was the same as the online/finishing machine (the one we'd watch for final approval with clients). Anyway, it was very normal for clients to come in, watch the final version of a music video / commercial and turn the volume WAY up, then leave, and no one would think to turn that machine's volume down. So it was not uncommon to be working late at night and - out of nowhere - the entire office would be filled with the deafening sound of a sheep. Absolutely terrifying.