Well I did the avoid cities at night and no fast-travel to small towns and it almost worked. I did get one daylight attack in Whiterun and I had to reload about four times because Adrianne kept getting killed. NOTE, if she didn't keep trying to fist fight with a Master Vampire this would have never happened. Guards all around she could have just ran away or cowered so the enemies ignore her.
This is whats wrong with the DLC, not that the NPC's die, it's that they die stupidly. They do the same when dragons attack also. If the NPC's would just let the guards do their jobs all would be good. The guards to attack the vamps and dragons so they are doing their part.
At this point I just turn off the DLC until I am ready to run a character straight through it. It's about the only way to get around the dumb AI of the NPC's during the vamp attacks.
Note, I did have one random vampire attack in the wilderness long after I beat the DG MQ. It's the one where they killed off some Vigilant and took their clothes. I haven't had any attacks in a city or town since, but they still appear in the wilds apparently.
Seriously true. I get mad when Belethor runs out of his shop at night and starts smacking the master vampire while the guards go around swinging randomly, then I shoot an arrow and someone runs in front of it stupidly, and the guards say OH NO HE HAS A BOUNTY! Then every guard attacks me and Belethor sits their attacking the vampire by himself...
Belethor should not be smacking vampires! lol
When an attack happens guards should attack, and civilians should run into their homes. Some do, but random freaking ones that you really like to use just sit outside and fight.