But a good many stories in other media succeed on delivering that gut punch. The hero IS fighting for the house and the blue babies and all that.
And then the end comes. There's one more thing to do.
And the hero has to do it.
And its going to cost them the house and the blue babies and everything else they were hoping for.
Otherwise, what does a sacrifice in a video game even mean? My hero dies at the end? Well fine. I was done playing him anyway. But if I have to sacrifice the things I wanted to fulfill the duty I was tasked with, then it means something. Then it actually feels like a sacrifice.
And I have to take issue with the OP. The heroic sacrifice may be cliche in any other media but not in video games. The hero almost always wins and gets everything he wanted (or at least can work to get everything he wanted.) And its because we feel that closer connection to the hero so its harder to accept that we die.
But thats exactly why its important that we do occasionally end a game with an unavoidable sacrifice of some sort. Because in this media, we can feel that sacrifice more intensely than is possible anywhere else. You're invested in the success because you're doing the work, so the sacrifice, rather than affecting you by way of your attachment to the character, actually affects you directly.
If you leave open a "golden ending" option in an rpg, it tends to invalidate the other "lesser" endings, especially in an age of multiple saves and game wikis. It becomes akin to your character dying in the middle of a level. You simply reload and try again and get it right and nothing bad ever actually happened. The way we're conditioned, if we get the less than perfect ending or the bad ending, it means we screwed up and we have to reload and try again. Just like with all those times we die in a level, that less than perfect ending never happened because we reloaded and did it again and got the perfect ending.
Now this is where I'm hoping that DAI kind of takes a page from its own book. I think its easier to accept the sacrifice if we choose what is being sacrificed, you just need to make sure our choices are all things or people we care about. Like we all hated the scene on Thessia where Kai Leng got away with the Prothean Artifact because we got no choice, but what if he can get away with the Prothean Artifact but only if you're willing to sacrifice Liara's life? Then it becomes a little easier to accept that he got away (even if he taunts you like a smug jerk), or you get a nice gut wrenching scene where you have to bury your teammate and ask yourself if it was really worth it.