Invisibility is a spell that can do half the job of a good thief. Hold person accomplishes something that for most dedicated spellcasters is really hard to do in a mundane manner. Many of the others are as or even more situational, but when the situation does arise they accomplish something pretty cool.

If you want (slightly) stronger magic users the easiest thing to do is play E8...