I think you left out a lot of the most powerful spells in the game, the ones that don't cause damage, don't change the battlefield but affect creatures on the battlefield. Things like Fear, Hold Monster or Dominate Person.
These kinds of spells are for the most part the most powerful offensive...