I think the term I'd use, for myself, is bitter-sweet. But I guess like with the other Bethesda games, I'll be waiting for those texture packs to make the game what I should have been out of the box.
Since Bethesda is shooting real photographs with cameras that they turn to textures,I think that in Skyrim they will include good enough textures from the beggining.
Crysis uses 1024x1024 textures,while Oblivion used 512x512 textures.
Every single digital camera can shoot well above 2048x2048 pictures,and since there are machines capable of using 1024x1024 textures,I can't see a reason not to include textures of that quality.
There isn't a reason not to include Crysis-grade textures in Skyrim.
They already have them at bigger resolutions and they make them smaller in purpose.
Giving us higher resolution textures won't be hard or expensive for them.
I think there is a possibility that we will get 1024x1024 textures!
I also hope for it.