I know from a friend that Skyrim looks really realistic.
As I know, you can use mods to increase the fun of playing.