Even if some mod support is allowed for consoles, it won't be the same. with the amount of tweaking you do for things and having a large part of the process be on your end (though there are a lot of auto installing big mods, true) as well as the switching out load orders, using different tools to tweak things etc, it just really wouldn't be anywhere near the same. i could see them having some of the bigger auto install mods allowed on the consoles, but the modders will almost positively be doing almost all of it on pc and really for mods, the pc is the way to go.
i can understand those that would do the console though, even though i think it'd be awful. i have a super mega intense gaming rig and demand perfection out of my games performance/graphics but not everyone wants that so they're willing to exchange it and while i'd never do that, i can definitely see the reasoning behind it. i like the vanilla games as well but with mods you can reallly change things and i don't mean like huge gameplay element overhauls (i like to keep the gameplay normal unless its really broken) but for example in morrowind i have like 6 tools active, tons of fucked with settings in morrowind graphics extender, 64 mods from that morrowind sound and graphics overhaul and it looks absolutely stunning and plays better than morrowind ever has before. with the pc there's a lot of freedom and control which i really love in games and as such i'm willing to pay a high price for an awesome computer to be able to unleash the max potential of all the games (especially elder scrolls ones).
anyone buying bf3 tomorrow? i'm thinking of picking it up either tomorrow or over the weekend since i'm sure the store will be packed and crazy and i'm still super into The Witcher right now, but i'm definitely pumped to play it single player and online (which is unique for me because i don't play ANYTHING online).