I see a lot of problems with making mods work for console.
- Software limitations
If a mod screws up something, or you need to tweak a .ini file, you can't go into the game files and fix that. A lot of PC mods require 3rd party software, like scrips extenders and other plugins. Other tools, like mod managers are also essential to prevent conflicts when modding, these things don't work on a console.
Some of these things can probably be made console-compatible, but if will require a lot of extra work and permissions from Sony and Microsoft.
- Hardware limitations
A lot of mods include high-poly meshes and/or high resolution textures that will cause performance issues on a console. Mods that add new statics and NPCs will also cause a performance hit.
The fact is that mods that add custom content of high graphical quality, or other visual additions to the game won't work well on consoles. Installing advanced mods (like FCOM...) won't work on consoles, and other third party software won't work if the creators don't get permission, and then put a lot of extra work in it to make it console compatible.
The most advanced or good looking mods will still be PC exclusive, since the console won't be able to run it.
Mods can screw up your game on the PC, and if Bethesda, Microsoft and Sony want to prevent these problems on the consoles I would propose a limited CK for consoles, and an incompatibility between the not so limited PC version CK's mod files.
As long as console modding doesn't affect my PC modding in any negative way I don't really give a [censored] about the consoles, but if console compatibility somehow messes up the CK for PC, then I and a lot of other PC users will be really pissed off.