Storm of the Century. Grease Fire. Shockwave. Entropic Death. Improved Drain. Plus all-around a wider selection of spells offering far more tactical options, especially with superior range and battlefield control.
Now, it was totally and insanely unbalanced (especially Storm of the Century) , and nice that they tried their best to balance classes better in DA2 as well as improving cross-class cooperation, but for all its over-poweredness, the magic in DA1 was still way more complex and fun, and really made you feel like you had a large-scale, long-range effect in fights.