Well its something Valve might tackle if they truly are working on a console as it'll undoubtedly tie into Steam which has Steamworks where, in the case of Skyrim, content is shared.
I'm not sure if the problem is the management of such mods: how, on a console, would they propose to easily...