I'm lvl 81, I've never had an NPC die from a dragon attack before, yet I have 3 ghost towns in only a couple of days as a result of this DLC. Why you ask? I will explain a few points.. .Slowly...
Dragons are large, very visible targets. They can be seen via compass from great distances away. Their attacks are slow and very predictable. They will attack the last thing that has attacked them, meaning more often than not, guards with bows. Music begins playing the moment they arrive and they are quite vocal about it. When a dragon attacks, it is all against one. The dragon will switch targets often, and provide long pauses between attacks while it flies about allowing NPC's time to recover.
Vampires are small, and fast and can not be seen from great distances via the compass. Their attacks are fast and powerful with intermittent summoning. They will choose targets at random, more often than not the nearest living thing. Vampires can spawn on the opposite side of a hold without any indication they are there. At higher difficulty levels they can kill non guard NPC's in a single strike, at roughly 1-2 strikes per second. These attacks can happen and be quelled all without the PC's knowledge of said attack on the other end of the city. When a Vampire attacks it is not all V.S. one. It is often 3-5 well armed targets accompanied by Death hounds and magic V.S. a number of NPC's in clothing wielding iron daggers in the midst of guards.
The problem people such as myself are having, is not the Vampire V.S. PC. It's the fact that they can spawn on the other side of the hold undetected and wreak havoc on the NPC population before you have a chance to react. One such example. I searched Riverwood for vampires. I spent a good minute looking around and found none. I then entered the tavern, did my bussiness, and when I left, I was greeted with a death hound killing Meeko (A dog follower) while the screen was still un-fading from black. He was dead before I even raised my hands to cast magic.
These attacks can not be stopped, and will happen for so long as you play Skyrim. These attacks can actually break your game removing quests, merchants, and other NPC's. This isn't a matter of skill, or "Killing them before they kill the NPC's" These attacks make the game tedious and paranoia producing. As I said before, I searched top to bottom when entering Riverwood and found no vampires. Yet they still spawned in the town after I had looked specifically for them.
Dragons are vocal, you know whether or not there is a dragon the moment they appear. Even without music, you still hear the tell tale shouting of the dragon in the background. Vampire can make no such noises, and can attack the NPC's quietly. Sometimes right under your nose. I was speaking with Adrianne at the forge of Whiterun, all the while Heimsker was getting his throat removed by a couple of lovey vampires.
After doing all of my townlike bussiness, crafting selling, etc. I wandered up to Dragon's reach to boost my enchanting only to find half the town dead surrounding the Gildergreen... Reload and redo 15 minutes of selling, crafting, reorganizing etc. That is not fun, a game mechanic should not make the player paranoid and make the game itself tedious and stressful. Unless of course that is the point of the game, that is not the point of Skyrim.
I enter a town, slow time, or wirlwind sprint around searching every nook and cranny of the town for vampires, then do my business. and before leaving again, I re-search the whole town for dead bodies just in case they spawned after I had searched for them the first time. (Such as they did in Riverwood) That is not fun in any way. Being paranoid over your towns, constantly having to check on everything. This isn't Dovahsitter. It's Skyrim, your supposed to be out killing dragons, not babysitting the townguard... And that is what has me up in arms. Dragons I can deal with, not genocidal assassins in the backgrounds of my town removing my quests and other game content. DLC's are supposed to expand on the base game, not remove it....
EDIT: Oh, and I'm not against the idea, I quite like it, it just needs to be tweaked a bit. As it stands, if they wipe out your town, that's it, the town is dead, it does not repawn, new people don't move in, yet more and more Vampires still keep coming no matter what you do. That needs to be changed.
Having the main town I live in Whiterun be dead, kind of makes the game no longer fun. Riverwood, Whiterun and Markarth are ghost towns because of this DLC. Right now my only work around is to not go to towns, or just keep searching/killing/reloading till I manage to save everything. Which could take hours. I spent at least a half hour stopping the solitude attack. They spawned near the Legion fort and started killing off the legion blacksmith/quest givers.
i agree with everything you said, i made my own page against the vampire attacks. people just need to look at the future of the game and realise that everywhere will become a ghost town, paranoia will kick in because you may think you saved the town but the chance of vampires spawning on the other side is very annoying on top of mysterious travellers getting into peoples homes and murdering them. no-one wants that kind of stress in a town/city