Place it right after the repeated mistake lands and before the reaction shot cuts away. Pair it after a mission failed sound for a game fail, then follow it with a ba dum tss sound when the moment turns into a joke instead.