Out of those two fan sites, I tended to prefer Victor's spell ideas for the four Colleges that weren't released, e.g. Amber, Celestial, Gold and Grey.
What I always thought was rather inefficient in the official AHQ Rulebook was the following Spell:
INFERNO OF DOOM
Components: Fire Dust and a Dragon Tooth
[...] Any models, friendly or enemy, which fall under the fireball template are automatically hit. Roll 7 damage dice to see what effect a hit has. Before casting the spell, the Wizard must make an Intelligence test; if it is failed, only 5 damage dice can be rolled. ...
It required two spell components so the Wizard is not allowed to move during the turn in which he casts the spell. Plus it needed an Intelligence test to do full damage.
Whereas 'Flames of Death' which used the standard one spell component did 5 damage dice, and it could be cast on the move. Therefore, you could "tactically" move position and if you really wanted cast it twice in the similar timeframe theoretically doing 10 damage dice.
The area of effect covers an area 3 by 3 squares (covers 9 squares in total), which I didn't realise when I first read the rules last century. Partially due to the fact the Fireball temple was 2 by 2 squares (covers 4 squares in total). Furthermore, Ranged Combat uses cardinal directions when counting the range distance.
For offensive I tended to like casting 'Flaming Hand of Destruction'; it does what it says on the tin, and the roll average would instakill most opponents as it was directly automatically forcing the target to lose as many Wounds as the roll result.