Morrowind's probably the TES game with the deepest RPG elements. You can pretty much do anything and it has several endings. The only downside is that combat. You have a hit percentage that activates for each swing, IIRC. Be prepared to miss a lot even if your weapon goes right through some douche's face.