Place it right at the peak moment of a fail or reveal, after a sudden suspense sting builds the tension. Follow it with the faaaa meme sound for a longer tail, or precede it with an oh my god wow reaction to set up the shock.