I didn't use very many mage skills, but you can check out the following topics for advice on which spells are considered effective.

Kaan's Mage Guide

Playing a mage character...