In act one there ARE no especially good spells.
From act 2 on hammer may be the best spell in the game - does nice damage and may stun any enemy near where it lands. For hurting many enemies at once lightning storm is a good choice - my casters pretty well rely on those two the entire game.