That's what happens when you don't got tessellation or parallax occlusion mapping.
Or simply not that great normal maps.
Take a look at Crysis's parallax occlusion mapping. It's amazing. An otherwise flat surface looks real.
http://wiki.polycount.com/ParallaxMap?action=AttachFile&do=get&target=crysis_parallax_occlusion_mapping.jpg
http://windows7themes.net/wp-content/gallery/crysis-texture-mod-parallax-occlusion-mapping/9.jpg
http://img16.imageshack.us/img16/9669/crysistexturemod.jpg
Visually, Skyrim would benefit heaps of things like this, because a lot of Skyrim has rocks and stone-walls/floors and such.
It sure would look nice, but the pictures you showed even they are mods of Crysis.
This game is developed for consoles in mind first and they are 6 year old tech and they have limited amount of memory , no way they can EVER do what your pictures show.
I know this is sad cause PC players always suffer, which is especially the case since Todd is making sure PC will look the SAME as it does on console, he wants PC to be 6 years old.
We will get higher textures but it really seem that BGS couldn't care less about PC and sort of just tossing in higher textures cause if not, the industry and game reviewers and us PC players would go nuts.
I can't for the life of me understand how MS and SONY want to keep these consoles for many more years, that is insane.
Since after 5-6 years we are already starting to react to them getting a little long in the tooth when it comes to graphics, IE lacking.
So imagine another 4 -5 years of absolutely zero change, at least there was change during the first 5 years, but they've hit a wall now.