I have to say I was in the same boat with you, I saw the dragons and was all like "Yeah cool, couple dragons in the game whoopdy friggen doo". Then I heard there were going to be a lot of them, rather than just one or two, on top of that, what mainly got me was the "If you kill a mans brother the game will generate a quest for the brother to come after you". I don't know if anyone remembers, but this was somewhat slightly hinted at in oblivion but either it never worked 100% or wasn't as clear cut as the Dev made this sound.
I love games that think for themselves, I hate killing someone's sister, looting their corpse then turning to the (insert sibling here) and selling everything I took off of her without anyone batting an eye. I hate to use "realism" when referring to a game with dragons and hairy men with pig tails, but it just feels so unrealistic so I'm glad something of the sort will be added to Skyrim.
I agree 100% i think that it's going to be an all round great game. Replay value will be awesome as well which in and of it's self to me anyway is a huge selling feature.