I would also place my vote for Morrowind. But yes, make sure you have as much RAM as possible.. this becomes especially important when you begin adding some of the user-made excellent plug-ins available.
I was running Morrowind on an old (bought 2001) computer until fairly recently, and it was a real slog at times, so I also suggest you look at ways to improve your game performance. I think there are some posts about it in the sticky thread we have called "Morrowind Yellowpages."
The best part of the NWN Diamond Edition is the two expansions you get.. but the original campaign is pretty lacklustre.. largely because it was primarily intended as a multiplayer game. They did not put all that much effort into the single player campaign. I started the NWN1 OC several times.. but I never managed to finish it.
This probably goes well afar from MW (don't shoot me please, Fable

), but as a very brief aside, given the topic of your thread, if you are looking for good, older RPGs with an amazing story and plot.. if you haven't already played it, I highly recommend Planescape Torment.
Welcome to Game Banshee btw!
