Originally Posted by Fluent
Everyone has posted some good info so far, and I'm a PC gaming noob but I would recommend Might and Magic VI: The Mandate of Heaven. Very enjoyable game and very much playable today.
You get to create a party and the combat can be played in either turn-based or real-time at the press of a button. Lots of skills and stats to ponder, lots of quests, guilds, loot, etc. Very cool game.