Put it at the end of a build-up, after a suspense cue such as Dun Dun Dun, so the reveal lands as the payoff. Follow it with MLG Air Horn only when the moment is big enough to deserve a second cheer, otherwise let the reveal stand alone.