It depends on the game, but generally I find something else disappointing - that in many RPGs the moment you are finally powerful and have all the cool items and weapons.. the game ends. This was especially in Fallout 1 and 2 for me.
Deus Ex (2000) - a game that pushes the boundaries of what the video game medium is capable of to a degree unmatched to this very day.