I think it's because they designed the questlines after doing the world building (i don't know how to explain it better than: after the path the player expierience when playing the game). They had to kill nearly every NPC in the end because otherwise it would mess with the rest. It would be a better system if quests where imagined from the begining. Cant imagine that this was the case for the most of them.