Without fully seeing the newer magic in "Fire" (and not having enough time to browse this whole thread) here are a few spell ideas:
Dimentional Sorcery:
L2 - Longdoor = teleports the caster (caster lvl +1) squares in any direction
L3 - Mass longdoor = Teleports caster's stack (2 + Spell extention rank) squares in any direction
L2 (3?) - Shifty Defence = Makes caster or target invisible (hidden) until they attack or the spell is dispelled
Dimentional Summoning:
L2 (3?) - Summon Dimentional Shambler
Mind Summoning:
L2 - Summon Mind Stone = Can see all units within (2 + Spell extention) squares of caster. Perminent until dispelled or caster moves. Doesn't work on undead.
L3 - Monsters from the Id = When cast on an enemy stack, units must resist or flee one square in random direction from mental horrors. {good for breaking up those stacks of doom}
Water Divine:
L2 - Well of Life = +3 Health as long as unit stays in the city. (also maybe +10% healing rate)
Air (All):
L1 - Smother = Reduces fire to smoke or smoke to nothing (50% chance or something)
L1 - Fan Flame = Turns smoke to flame (50% chance or something)
Air Sorcery:
L2 - Air walking = Makes all terrain 1 MP. Can pass over impassable terrain. Caster only.
Fire or Lightning (All):
L1 - Spark - Creates smoke in woods (50% chance or something)
Fire Sorcery:
L2 - Firebolt = As Fireball but no collateral damage. Firebolt has the Marksman ability and is

3. (fireballs are great but they ruin the fun of combat for me)
That's all for now. I have to say how much I love the spell system in FFH2!! The only drawback I see is the ability to have tons of mages with fireballs or an Amurite army all able to summon skelletons. While it is fun the first time you completly obliterate your foes, the replayability is nil for me.
Anyhow, congrats on the release of "Fire". It has been the best Civ experience for me so far!!!