Nope, not going to happen.
First, Microsoft and Sony are currently unwilling to allow mods on consoles. You can get user maps on Halo (Xbox) and Unreal Tournament 3 (PS3), but those aren't intergrated into the main game like Fallout's mods are.
File system is different. Mods would have to be ported, tested and debugged, who's going to pay for that?
Who's going to pay for the time and effort to select these mods? And with what criterea?
Finally, talk of console modding is forbidden on these forums since it breaks the EULA and is illegal.