looking at those pics, and looking at a game like uncharted 4... I don't see what in those pics won't be achievable on the PS4. Albeit running at 30fps.
The real question is, how will the elder scrolls 6 be with "Mods"?
another thing to consider is that the mds aren't hogging down PCs simply cause they are running ridiculously powerful code or assets. They are at the end of the day mods. Mostly along the lines of increased texture quality and detail (which in turn require more mem bandwith to stream), better lightning settings (its not like they are writing new code for the lighting, they are just tweaking levels already in the engine, and other tweaks like AA, DOF, AF...etc.
They hog down systems cause the games engine wasn't designed on a base code level to run most of what they are doing, Its quite literally the epitome of running unoptimized code and/or assets.
