Stupefy

Stupefy — the Stunning Spell — is the wizarding world's all-purpose offensive workhorse. Properly cast, it produces a bolt of red light that strikes the target and drops them unconscious where they stand. There is no lasting damage and usually no injury beyond whatever they hit on the way down. The counter-spell, Rennervate, brings them back almost as quickly as the Stunner took them out.

What makes Stupefy so useful is the combination of speed, strength, and reversibility. It is fast enough to catch a moving target, powerful enough to be a real threat in a duel, and clean enough that you don't have to worry about killing someone you didn't mean to kill. Aurors are trained on it heavily. The DA ran it as a foundational drill. Order of the Phoenix members used it as their default. In the Battle of the Department of Mysteries and again at the Battle of Hogwarts, the air was thick with red light.

Stupefy scales. A single witch or wizard can knock out a human in one cast. Larger creatures take more — Charlie Weasley and his fellow dragon-keepers needed several coordinated Stunners to bring down Norberta the Norwegian Ridgeback, and even then the dragon was up in not long. Acromantulas, trolls, giants, and other large magical creatures generally require either multiple casters or specialized variants of the spell to be reliably stopped.

The spell's main limitations are concentration and aim. A distracted caster casts a weak Stunner. A panicked one misses entirely. And while Stupefy is the most popular offensive choice for a reason, it has a famous counter: a strong Shield Charm absorbs it, and a sufficiently large duelist can sometimes shrug off a glancing hit. Still — for sheer flexibility, no other offensive spell in the curriculum gets close.