I thought the guys over at SE had already confirmed they will not make a SE for consoles. Not that there is any chance that either Sony or Microsoft will allow anyone to use this in the first place, which is probably why they aren't going to try it anyway.
As a result i expect mods to be far more basic for consoles. Another limitation is EULA and such rules, so you cannot just mod everything in as there will certainly be rules stopping you.
And finally, performance. The consoles are static in their performance, just dumping in a bunch of really intense mods and things like HD textures will probably tank the performance harshly. Which might also result in modders limiting their effort, afterall if you make an intense mod for pc not everyone can run it but a lot still might. If people cannot run it on console, no one can run it on console.
I suppose a final limitation could also be buttons. Big mods often use extra button prompts on pc that were previously unused, that is going to be a real challenge if not outright impossible for a controller that probably doesnt have a single button to spare.