Put it right after the fog or blur appears and just before the reveal, then follow it with the It Was At This Moment He Knew sound when the mistake becomes clear, or cut to the Fail Sound Meme when the character walks straight into trouble.