There was some Original Xbox games that had "console" features and those led to the TSOP/Save file modding. I know of only a couple games on PS3 that support "user created content" and that's Little Big Planet 1 and 2 and UT3 (Maps and some mutators) 360 version lacks even user made map/mutators. It simple Microsoft and Sony won't allow it and if you want to be able to release a game on there system you have to abide by there rules. Also with the patches on PC theres no middleman. Bethesda puts it up and you can DL it when ever you want. Once its released for PS3/360 they have to wait for Microsoft and Sony to post them on XBL and PSN once they are "Approved" and meet there requirements hence why it can take up to a week or so after the patch has been publicly released. It svcks but unfortunately it's how it is.
Also yes Skyrim was made for consoles in mind but once the Construction Kit is released for the PC the I am will to bet money with in a month tops there will be some AMAZING graphical mods/UI/Quests/Fixes etc etc. For us console players unless we can some how convince Microsoft or Sony to let us have a "Approved" version of the Construction Kit we just have to be happy with what we get from Bethesda.
EDIT: Fear of exploits is also a reason PS3 officially cut Linux support on there systems, people were using it to by pass security features in games allowing to use of cheats/mods. Also saw somewhere people were trying to use Linux on PS3 to some how made a PS3 Emulator (don't know if its true or not just something I heard) and it eventually led to Sony cutting support for Linux being able to be installed on the PS3 if it's patched to the current one. I think 1.2.3 is the latest you can have that allows Linux to be installed on it. Anything newer and it won't install.

Sorry.

... okay ...