Place it at the end of a build-up, just before the biggest visual lands, then follow it with a bass drop to keep the energy high. For a comic twist, follow a failed attempt with it instead, then cut to a fail sound for the contrast.