And among the buffing spells (although can it even be called a buff?), I would highlight healing. But I admit that it's a bit of a stretch to consider it a buff.
And jokes like "Ripple of Death" are also great for fighting a hero who has several units of one type (so they can run away) and for storming a city where there is a symbolic defense in the form of several level 1 units.