My favorite RPG right now is Morrowind because its really open-ended. You can do pretty much whatever you want to do. Fable, which is coming out for Xbox this fall, has a similar concept, but It's even better because the character ages realistically and the world is premanently effected by the different actions the character takes.