Skyrim has some pretty great textures. Especially with mods.
I actually think the original textures are better because they don't suffer from oversharpening. I don't understand why gamers want extreme sharpness and detail whereas movie fans who want the best visual fidelity turn the sharpness level on their tv's as low as possible.
It doesn't make a game look more realistic, on the contrary. This is just as bad as those old Unreal games where every surface was made of plastic, extreme bloom, piss filters, etc.