I think a sweet spell idea would be intangibility. Not through barrier walls/doors, but through the walls/doors inside of the house/cave/fort. You guys have any original spell ideas?

I would like a Destruction spell, that mixes Lightning, Fire, and frost in one attack, but I wouldn't know how that will work with the perk system.

Wish we could poison enemies, a sort of DoT spell.

Precedent : Arena had a Passwall spell.

Anyway, yet again, one more time :
Haste, slow, jump, slowfall, water-walking, drain stamina regeneration, drain magicka regeneration, drain melee damage, the rest of the bound weapons, poison damage, more summons : not just Daedra, but bear familiars and making ghosts/wraiths by forcing spirits to return to their corpses, on-touch destruction spells, barrier/wall spells.

That's without spells that don't work with the (unmodded) game world such as levitation, or anything that steps on the toes of other skills (charm, open lock etc.)

[Edit : deflect arrows, expert level runes and cloaks, who would like to summon a swarm of ghostly skeevers?]

i REALLY think that they should bring back the unlock lock spell from oblivion ive just realized how much i used that spell

Paralysis rune, bound crossbow, fortify health and stamina regeneration, silence, spider familiar, poison cloak, fortify melee damage (equivalent to temporary smithing) and cure disease as a master restoration spell.