As for a console version, speak to Microsoft and Sony. They are the ones that won't allow this level of modding on their consoles.
Not entirely true, Bethesda and MS/Sony just have not come to an agreement on how it chould and should be implemented, and all the other additional issues such as cost of implementation, storage locations and fee's, licencing, data ownership, etc etc.
They do actually allow titles that allow full customisation of the game. Trials HD and the more recent Trials Evolution n360 both allow customised content for free. Trials Evo actually has the identical creation tools that the developers used to make the game levels, so anything the devs can do the player can do to and more of it and all for free.
Similarly Little Big Planet on PS3 allows users to create their own content for the title.