Every game has a failure ending.
It's called a game over. 
...In all seriousness, I find the "character dies at the end" ending variation is a thing best done in moderation, and BioWare's already given us Dragon Age: Origins (wherein the Warden can sacrifice him/herself to end the Blight), Mass Effect 2 (where Shepard can get killed if he sucks enough at leading a squad into suicide missions), and Mass Effect 3 (where you have to basically do a 100% completionist run just to see a hint that Shep might be alive at the end). And, if you want to count every story instance of a protag dying, they also gave us the option to sacrifice Hawke in Inquisition.
The possibility of your main character dying loses its punch if you expect it. It hits hardest when you don't see it coming. So the only thing I hope for is that BioWare will be smart about how, when, where, and why they deploy that particular curve-ball.