TES graphics have never been that impressive. Consoles aren't "holding them back", there are plenty of console games with much prettier graphics than TES. TES has always been aimed at
midrange hardware. Their games have always been about world building and design over graphics.
Skyrim is a massive improvement over Oblivion, what more could you expect?
Mods can make improvements, texture packs stop things looking blurry close up, some post processing stuff can look alright (some of them are pretty bad too tbh) and little things like enhanced night sky and sunglare mods can add a nice touch.
Some of the morrowind/oblivion mods made the games look much better. Especially after the graphics began to look dated.
The game looks fantastic imo. I'm not too bothered about graphics mods at this stage, especially not if they decrease performance.