I don't understand that fascination with "you can kill everyone" at all. I mean, that has little to nothing to do with actual roleplaying. It's just fooling around with the systems and you shouldn't expect that you will be able to continue the story as intended after you killed a whole town or so. I think you should definitely be able to fail the main quests and side quests if you make really wrong (and stupid) decisions.