Well. People wanted danger, and a way to have their world seriously altered. There you go.
I can't help but think this is split into 2, possibly three groups.
1) Old school games love this (Dating back to Arena-Morrowind)
2) Newer TES players who started with Oblivion who hate this. Take it out!
3) The tweeners. These guys like it, but would like it to be fixed a little bit.
There could be a possible 4th
4) Old school TES player who hates it.... I'd assume these are rare, though.
People been asking for ways to break the MQ. Break Quests. Kill NPC's, even through non-direct means...Just for revenge (even since Oblivion came out). It also adds a bit of realism to the game that the last TES was missing (no one could die...pretty much all towns were super guarded).
They really need to keep this is. Maybe work out the kinks? But removing it would totally kill the feel/nature of this DLC. Basically a lifeless addition to Skyrim. IMO, it needs to stay.
I started with Oblivion, but I've played all the TES games except battlespire and redguard (Morrowind is my fav). I like challenges and danger and yes we wanted to be able to change the world, but this is just annoying and obnoxious to me. This is coming from someone who hates essential npcs too, so don't think that I'm just being whiney. If they wanted to make us feel like we actually could change the world, they should actually give us choices (actually fullfilling the prophecy and blotting out the sun for real?) or they should at least have given us an incentive to accept these attacks (if you're on vampire side, you actually participate in conquering cities with the vampires?) npcs would still die, but at least it would be slightly less annoying, random, and obnoxious and more fun. For me it's the annoyance factor really. You can only keep fighting these guys for so long until people start dying off.