Place it at the peak of a reveal, just as the surprising image or result appears, then let the reaction breathe before cutting to the next scene. If the surprise falls flat, follow it with the awkward moment sound; if it turns into a disaster, follow it with the womp womp fail sound instead.