I'd love it. It's all in the execution though.
Generations is good btw.
I'd actually not mind the Warden being killed if it was done in a suitably heroic manner, the problem with Hawke's possible death in Inquisition, Kirk's death in Generations and Shepard's death in most of the endings of ME3 (and the ambiguity of if they survived Destroy) is that all felt ultimately a tad hollow from what they could have been?
Contrast that with Loghain's sacrifice in Inquisition, which I think was better than serving him up to the Archdemon. In Origins, he's something of a death seeker, not expecting to live through the Blight and being surprised if the Warden choses to sacrifice themselves instead of him to the Archdemon? His death seems to come somewhat as a relief, going out in a blaze of glory to restore his name, without doing any of the hard work or putting any effort into actually atoning for his crimes?
In Inquisition however, if alive, you see saw that he'd had ten years to redeem himself and atone for his mistakes. He's committed himself to the cause, despite all the scorn from his fellows and this stubborn determination has actually made him lives up to the Warden's ideals, more than his comrades in Adamant are. While going out against Nightmare was him going out like a Big Damn Hero like he wanted, this time he did it not to save his name and reputation, but to save his friends and allies and let them escape.
The other sacrifices seemed forced and made them far more underwhelming? It'd have been better to not have an option at this point actually, making it so that the Warden-ally always sacrifices themselves (as per their ideals) to get the others and Hawke out, which would have been far more in-character?
If the Warden came back solely to be killed off, it'd be better if it was in a heroic last stand to save their fellows, than something akin to falling off a bridge or getting killed by a giant tar creature, like some simple redshirt? Sure, in the real world, people don't get to chose how they go out and sometimes it is ignoble, but I think that part of the fun of fiction is we can give our characters a good send-off?
Personally, I'm fine with them being happy off in the sunset and to leave them there, but a heroic, bittersweet ending to their story I'd not mind either?
(And Generations is like Insurrection, a two-part television episode that thinks it's a movie, when it's not. Cut out the filler, tighten the plot, give it more action and make Kirk's and the Enterprise-D's death more meaningful and less facepalming and then it'd be a good movie)