Place it right at the action beat in gameplay edits, speedruns, and tabletop recaps, just before the visual effect appears on screen. Follow a failed cast with a flat reaction sound for the miss, then use a cheerful cheer sound when the next attempt finally works on a boss.