Put it at the exact moment a win is confirmed, then follow it with another celebration cue such as a ding or an air horn to extend the payoff. For a miss, place a fail sound before it instead, so the contrast makes the win stand out in the edit.