The fate of the protagonist should vary depending on player choices, and surviving the plot in a reasonably intact condition should always be an option.
As for how Bioware's latest games did in this regard:
(1) ME trilogy: the developers are on record saying that Shepard "had to die". They took this seriously, to the point that they refused to confirm Shepard lives in the much-debated breath scene, though I'd have to ask what *else* could it have meant? Anyway, as far as they're concerned Shepard *is* dead, the story sets you up for it early and sticks with it with the exception of two seconds after one specific variant of one ending, and it's pretty clear they don't consider Control!Shep as survival. So technically, survival is an option but the ME team did everything to show you they don't want you have that option.
(2) DAO: My personal favorite set of outcomes. You win the plot and you have several satisfying outcomes for yourself - continue as a Warden and go after Morrigan, become King or Queen, continue to wander the world with your LI - as well as the option for a heroic sacrifice if your Warden thinks avoiding the DR is worth giving their life for. In DAI you're told your Warden looks for a cure for the taint, which worked perfectly for me but not so much for some.
(3) DA2: tells you almost nothing about Hawke's fate, but you always survive. In DAI, you have an option for a heroic sacrifice (gods, does this get boring - can't Bioware do without those for any of their protagonists?) but you can also survive. A simplistic set of outcomes with Hawke always becoming an outcast after DA2, even in games where they were set to became viscount of Kirkwall. I didn't find this inspiring at all, including the options in DAI, but it's a better fate than Shepard's and leaves some room to insert your own headcanon. For now - surviving Hawkes will always go to Weisshaupt, no doubt a new opportunity for the DA team to kill them off.
(4) DAI: For me personally, the most unsatisfying outcome of all DA games, though still *way* better than Shepard's fate. In Trespasser, you lose your arm, your cool magical extra (I *really* resent that) and of four factions set against you, you lose against three. So you don't even win the plot, and any political ambitions you might've had after the ending of the main game are mercilessly crushed in Trespasser. The only choice you have is between obscurity and subservience. I might've considered this much better than Hawke's fate except that the main game set me up for some large-scale independent influence which Trespasser took away.
Now what about this Pathfinder? Rather obviously, I prefer a set of outcomes similar to DAO's, including the bit from DAI where you're told the Warden is looking for a cure for the taint. I want the option to survive or die on my own terms. I have yet to see a video game where a heroic sacrifice appealed to me as the outcome but I'M willing to contemplate it as long as it remains an option. Bioware's dominant thematic tendencies likely mean I'll never consider it worthwhile in one of their games, but who knows. More to the point, I don't want to lose in the end like the Inquisitor, and I don't want to lose traits that I've come to feel define my protagonist. Most specifically, if I get special powers, I really hate (imagine this word being used with the highest possible emotional impact) losing them, and even more I hate the thematic message that losing them is good, especially if it's paired with the message that normal is good. As far as I'm concerned, that circumscribes what options ME:A's protagonist should have at the end.