This is the best one IMO. http://skyrim.nexusmods.com/mods/16225. Its balanced and adds a level of complexity with new spell types and functions, no simple power scaling or eye candy like some others.

http://skyrim.nexusmods.com/mods/17353 is preparing to release its drastic overhaul in v4 within the next day or two.