A positive thing to let you experience the consequences of your actions. You are ignoring the fact that the game explicitly tells you when this happens, giving you the choice to continue if you like or reload a previous save if you don’t. It’s actually more forgiving than dying in most RPGs, which would force you to reload from a previous save.
It extends the town and surrounding areas, and adds quite a few new NPCs with associated story lines.