So Todd has stated that the Bethesdayteam is working with Microsoft (and Sony too) to find a way to bring Skyrim mods created in the Creation Engine to consoles. He hopes that he can bring the mods to consoles since so many people in their audience use them, but is skeptical that they will be able to find a solution before the release date. Heres a few short articles where I got this information.
http://www.escapistmagazine.com/news/view/109378-Bethesda-Wants-Skyrim-Mods-on-Consoles
http://www.tgdaily.com/games-and-entertainment-features/55462-skyrim-mods-could-run-on-consoles
This really has me excited now...
I imagine it would work something like the Halo3/ Halo Reach fileshare: a big archive of all mods which you can upload your mod to, then users can choose what to download from that fileshare (i'm guessing there will be a mod-size limit though)
My guess on cost is this: if this system is created, it will cost money to get to the Fileshare menu (like the Mass Effect 3 Cerberus Network if you didnt buy a new copy). That was 15 bucks, I would be willing to pay that if I could have access to mods. I imagine almost every console gamer would buy this because its so cool.....and right there you have made $15 x (# of gamers in millions) = $$$. Plus, I'm sure they'll create their own DLC so it would be quite profitable all around.