I'm a bit biased when it comes to dragons (as you can probably guess from my avatar), but I think Skyrim has done the best dragons ever in a game. <3
No. Ew no.
http://www.youtube.com/watch?v=vGZwS4LVd6E&feature=related The problem with Skyrim is that the game doesn't make the dragons bad ass enough that defeating them feels epic. In Vagrant Story, if you didn't come in with the proper equipment to resist their breath weapon, there's a fair chance that you could get breathed and that was it. Also, their damage resistance was to the point if you didn't have proper weaponry to fight them, you could be doing almost no damage. Of course, you could get to a point where dragons were easy to take out, but it wasn't handed to you on a sliver platter - you had to game the game to be able to take down dragons with ease. I'm not saying Skyrim dragons need to be Demon/Dark Souls hard... but, well, Bethesda should have tried to capture something close to that feel. They're too easy, and if you game the fights, you can one-shot them. Leveled dragon enemies shouldn't be one-shotable ever.
I guess there are always mods. First thing I would do is make dragons unable to be staggered. Second, make the breath weapons ignore magic resistance, only reduced by actual elemental protection. After that, I'd like to see some new dragon types. Thunder Dragons, Earth Dragons, Dark Dragons, Undead Dragons, Holy Dragons, and then maybe some special "Dragon Primes" that are meant to handle even the most insanely powerful players (Ruby and Emerald Dragons anyone?). Seriously, when you enter a dragon's lair without knowing what is to come, you should be fearful of the fight. I don't know if I've ever felt like I needed to bring some resist potions because I was under geared for a dragon fight. The closest I've ever felt to that in this game is the first time I battled a Dragon Priest and it wiped the floor with me. Every new dragon encountered should be like that, mopping the floor with you if you don't have the gear or the potions for the fight.