They could easily implement a Mod Store like Civilization V where you pick download and install mods that are uploaded to the Mod store. Players can then vote on them and they have to be tested for faults and stuff before they are accepted.

Yes this would mean they would have to hire a small team to manage the mod store but the mod store could be used on the PS3 as well at this point.