I like Phantasie, Wizard's Crown, Might and Magic 1-8, Ultima 1-7, and 9, Baldur's Gate, Planescape Torment. NWN and NWN 2, Icewind Dale, Dark Heart of Uukrul, Lords of Xulima and everything ever published or developed by Bethesda Softworks that isn't online
I nearly always play a mage or mage hybrid in party-based games like this. In BGCoD, I chose a Dwarven ftr/shaman/thief multiclass for this particular play through. I already have dozens of hours in the game as someone put the link up last week at RPGWatch.
The game has about 10 maps to explore prior to the EA release and you'll hit level 4 or 5 as a single-classed character. My current may not quite reach level 3, but with gear I've got good melee damage and about 12 spells to sling around. It's quite fun.