I don't think the game needs a Red Wedding. I think it could use more difficult choices without easy answers.
Origins, for instance, you had the whole Orzamaar deal. Bhelen is a horrible person, is going to basically set up a dictatorship, but is going to do well for the people he supports. Harrowmont is a much better person, but is just not equipped to lead. Branka is another horrible person, but she's also brilliant and is right that the golems will help both your cause, the dwarves cause, and especially her own cause. It, however, could also mean the death of your companion (Shale, who would turn against you). That? That was well done arc, ignoring all the slogging around the deep roads.
The 'happy end' to Redcliffe, on the other hand, where you can just leave Connor alone for the week or so it's going to take to travel to the Circle to save him and he never sends more undead after the villagers, brainwashes his mother/uncle/the knights, or does anything but apparently sulk in a room waiting (in fact, you can basically go to Redcliffe early then go around and do everything else first, because hey, why not- nothing will ever happen!)... that wasn't a hard choice. Unless you sided with the Templars hard, with metaknowledge there's no real choice here unless you want your character to be evil/ruthless. Going to the circle gets you the best rewards, the happiest group, and there are no consquences.
I don't think Bioware needs to start killing off beloved characters to make you care. But if they want the game to be of the darker sort of fantasy (and do they, still?) they could put in more choices that are, in a way, lose-lose (or at least not win-win). They can put in consequences that actually mean something. For instance, if you Tranquilize someone in DAI, you'll get a ton of disapproval: but no one, even the ones that should really care (Dorian if it's Alexius, Cass due to her experiences...) says anything. Only thing that happens? A War Table mission you can actually ignore with nothing changing.
The game isn't 'not dark' because people aren't dying enough: it's 'not dark' because no matter what you do, nothing really bad happens (and if it does happen, it was inevitable and wasn't a result of your choices, IE DAII finale). There's no consequences to your actions that matter beyond minor companion disapproval and occasionally a failed wartable chain.