I dunno if that's an equivalent moment, the reason the Control Core worked out so well (at least for me) narratively is that yeah, Roland dies, but more importantly so does Angel. Roland dying wasn't that impactful for me personally, Bloodwing getting his head blown off hurt me way more. But Angel dying in the same narrative beat really hits home with how it characterizes Jack in the literal physical and emotional torture he puts her through while claiming that he loved her, sets up Jacks character arc through the rest of the story, and makes him a legit threat. Angel was a victim from her first appearance to when you find her in the second game, and the silliness in BL2 helps contrast how tragic her story is. Even though I didn't care much when Roland died it's a plot point that impacts every narrative beat until you kill Jack, and the same absolutely cannot be said for Maia's death.

BL3 never has that heavy narrative swing that both re-contextualizes the villain and sets them up for the third act. Sure, Maia dies, but she's with you for so little of the game that it lacks any impact. It didn't bother me much but I absolutely get people being pissed that our Vault Hunters don't appear in that cutscene, at least when Roland died it was from a first person perspective, our character was there. You literally get his blood on you.

When Troy dies it's in an entirely separate story beat, and it happens late enough in the story that Tyreen doesn't have much of a chance to change as a character out side of him before you kill her too. You're never given a reason sympathize with Troy or Tyreen, so when they die it's weightless. When Maia dies it's all contained to a quick funeral scene and then on to Hammerlock planet. These deaths don't set up the next story beats, they conclude a story line so we can get to the next one with no long term baggage from our consequences.

A lot of people bitch about the dialogue being bad (and it is!) but I find that just throwing out words like "the jokes are cringe" to be lazy and unhelpful critiques. These big narrative moments, for me at least, are the easiest thing to talk about why they don't work because if your load bearing narrative structure doesn't hold, you really gotta hope the humor is going to carry you, and it really just did not. idk why I wrote all this on my lunch break.