I'm fairly certain that Bethesda said that curration was going to be kept at a minimum. As in removing things that are illegal or break copyright laws or possibly breaks the rules that Microsoft set. That really only applies to a small percentage of mods that get made. So there will most likely be a great deal of mods available for the Xbox. And if it breaks the game? They're prepared to let that happen. That's the entire reason that the game will back up your save with a non-modded version. If your mod breaks your game, you go back to the unmodded save and keep going.
Also, it's likely that all mods will require a .esp and a .bsa. Anything that involves scripting outside of the native script, like the script extenders, will probably not work.