Mages

The Single-Superpower User -- not common in D&D, but very common in fantasy literature

The Battlefield Controller

The Sympath -- bases everything on contagion and similarity, e.g. voodoo dolls

Mage/Mundane

The Holy Warrior -- who almost never quite uses magic but is a bit to powerful to be obeying the laws of physics

Rogue-likes

The Omnidisciplinary Scholar -- whose primary ability is to know what you need to know, but may also be able to apply his knowledge in many fields, including magic, given enough time

The Psychologist -- who understands his enemies/pawns/allies perfectly