Place it just after the on-screen failure peaks, then follow it with the Mission Failed cue for a bigger payoff, or use the Ba Dum Tss hit first to frame the moment as a joke before the comment lands.