I'm sure there's a way to mod in gamepad support.
To be fair, I haven't looked much into it, but it's annoying to have to run a program alongside a game just to get the controls to work, which would probably require a lot of control mapping to get the functions to work the same between games.
But there is only one game I've played that was actually so bad on PC that I needed an Xbox 360 controller, which was Just Cause 2, but fortunately that is one of the few titles that came with the support.
I am hoping that Skyrim supports it, but there's not really a trend to base assumptions off of. Fallout 3 had it, but that was a GFWL title and it was
forced to have it. Fallout New Vegas had it, which was a Steam title, but it was made by a different studio and was using the same Fallout 3 assets. They may have just copied that feature because it was there. Will BGS use it for Skyrim? Who knows. I might prefer a keyboard and mouse anyways if a gamepad isn't an improvement, but the choice is good.