- Baldur's Gate: Hero either becomes a God or remain one of the most formidable denizen of Faerune
- Jade Empire: Hero either becomes a God-Emporor or remain one of the most formidable denizen of the Jade Empire
- KOTOR: Hero either becomes a God-Emperor or remain one of the most formidable jedi of the Galactic Republic
- Mass Effect: Hero either becomes Galactic Yog-Sothoth or is remember as the most formidable Space Marine to ever live.
There is indeed an annoying pattern, but if anything, recent Dragon Ages have tried to steer away
You could consider the fact that Baldurs Gate has a canonical hero in the FR D&D universe to make all of our BG heroes and everything they may have done that their canon hero did not effectively meaningless. If you just see them as well made video games apart from the D&D then you're right
It's true for Jade Empire, though that game never got a sequel or any other tie in materials that explain what happened after the ending. If it had I'm sure we would have learned what price spirit-monk has had to pay since the ending.
KOTOR........you can find enough opinions from others here about that, no need for me to elaborate. Personally I like to ignore the whole MMO and expanded universe apart from the KOTOR games.
The Mass Effect trilogy has the worst ending of all Bioware games to date, you become Starbrat's little ****** in the end. That ending was so bad, they essentially needed to reboot the franchise a galaxy away (I hope the Andromeda galaxy has cute space hunks besides Humans and Drell to help me get over ME3's ending). Tresspass is second, at best compared to that.
Being a Bioware protagonist always has a price in the end, but to date the Shepard and the inquisitor do get the worst of it.
I'm sorry but this is the best ending that any Bioware hero has had imo.
It's certainly better than Star brat, but that's not particularly high praise. It's far from the best Bioware ending though, it felt very rushed, for one.
Let's see....
My Inquisitor now leads the honour guard for Cass (who she is very good friends with) is married to Cullen who is still her commander, is still friends and keeps in contact with Leli as she raises Harding, Ractor and Charter as successors, has titles and holdings in kirkwall and is a very good friend with Varric who is viscount, is very good friends with Sera and does regular Jenny work with her, still keeps in contact with her good friend Dorian with only Josie, Blackwall and Vivie doing their own things now. She still has her contacts and is now foucvisng on protecting Cass and stopping Solas and the only downside is she lost her lower left arm.
All of our inquisitors end up slightly different.
Personally, while my Inq certainly respects Leliana he doesn't actually want her as his boss, however since there's no real choice to just give her the Inquisition without himself (and certain others) he was forced to formally disband it since he didn't much relish becoming a one-armed, glorified bodyguard for the Divine. The saddest thing, up there with being crippled, is that Dorian always leaves and you don't get the option to move in with him. Understandable considering Tevinter attitudes....but still a long distance relationship was kind of a bittersweet ending to the romance, for me.
My inquisitor would probably either move the Kirkwall, or more likely back to his father in Ostwick. Still having to move back in with your parent(s), or live of the largesse of a dear friend, as an invalid, isn't exactly something to be proud of for a young man of the Inquisitor's age.
Our inquisitor is also likely crippled for life and we don't know what, if anything, beyond a certain crossbow can or cannot be done about that. You do lose a lot of power beyond the mark from that, if you have to learn how to do everything all over again, you're essentially back to level 1 again and since your fighting days are done you're more than likely stuck at that pitiful power level too.
So in the end all my Inquisitor really has left from all his hard work, is a long-distance relationship, some new friends (though being from the Circle he probably lost a great many old ones) and his father. Maybe his mother and siblings as well, though they are never mentioned in the game. In my headcanon one of the reasons why they are close enough that his father was willing to bribe the templars to let his son life at home for a few months each year, despite being from a devout family, is that the Inq is either his only child or else his only surviving child. Given Leliana's changes he might even stand to inherit his father's tile now.
Ending up in the gilded cage of a noble in either Ostwick or Kirkwall, crippled and without his lover does make the ending kind of bittersweet for me.