Won't happen.
Main reason is technical. it's requirements are higher than the game itself as it's capable of viewing a lot more at any one time. And since the consoles are well below the requirements......ain't happening.
Next, Sony and MS WILL NOT allow modding on this scale on the consoles. We're not taking a basic map editor like in LBP or Halos Forge, we're taking about an editor that can essentially change almost anything in the game. Thats a huge margin for things to go wrong.
Next, you suggested better textures. NOT POSSIBLE. You try and do high res textures like the pack the PC got (That only high end PCs can even manage) and you would very quickly have a melting, hot lump of plastic.
Finally, the Creation Kit is the same tool the Devs used to make the game. It's released almost as is (minus tools and applications licensed from third partys), hence why it's not new user friendly. It's released to the PC public becuase it can run on a PC and any PC thats close to the console specs can't run it (Actually a PC with those specs couldn't run the game either).
Bethesda aren't going to spend time and money making something for the consoles that is going to cause consoles to break. And they aren't going to spend the same making a basic tool capable of running and litting you do only 2% of what the Creation Kit can actually do.
For the time being and until at least the next gen, mods are PC only.