Todd Howard has a tendancy to say one thing in an understated way, and then surprise us with something better. He is hugely active in the development, even considering his role. I would sincerely hope that he includes a super-mild tessellation system that does NOT radically change the way skyrim looks. Just slightly enhances it (like dragon age 2), then he will allow for a SIGNIFICANTLY wider range of modders ( i would say it would go from 1-2 retired modders, to about 100ish) to actually make it a significantly greater thing at a later point in time, making all those console users feel justified for long enough to make it unsung.
Bottom Line, I just really want tessellation, and if it means I purchase a 500 dollar card, although I am poor as dirt, then so be it. But the technology for tessellation suits skyrim 50 .... no... 100 ... no... 1000 times more than any other game released since the hardware level tech was made available and hardware that supported it.
I would actually argue that skyrim is the game that needs tessellation the most out of any game ever made. The non-tessellated engine actually looks like the textures are tessellation enabled. They look flat on purpose. As if some system is already in place ready to make them bump up.