Put it at the end of a setup, after the tension has built, then follow it with a reaction sound rather than another effect. Sudden Suspense makes a good lead-in, while the Wrong Answer Game Show sting works well right after it when the reveal goes badly.