Although it may be too early to tell, but how would re-texture and graphics improvement Mods translate to the console systems? Since the CPU and GPU architecture seems to differ from the modular nature of PC, would the framework of the PS4 and Xbox One be hard pressed to handle these upgrades?

It entirely depends on how Bethesda.net is set up. For performance reasons, they might say no textures for console mods or something. We won't know until they tell us.