The Almighty Aardvark said:
You know, this part made me think:
But in a video game, the plot revolves around the protagonist by necessity
Could a game ever work where you are not the star of the show? There's someone more competent than you, around which the story revolves, and you are an observer or support. I'm curious if this could work, although it'd definitely be difficult to justify it to the people asking "Wait, why am I not playing as him?"
That might be able to work... I can think of one example, but it leans heavily on competent AI.
You can see it in MMO's, which rely on teamwork, and where AI incompetence isn't a factor (due to the multiplayer nature)
OK, so by design an mmo party is intended so no one person stands out.
But boiled down to it's essence, it is basically a 3 man team. (larger teams are just multiples and variants of this)
Dps, tank, support.
Thematically, the tank is usually the hero type. (though not always Star Trek online follows this model closely, and the 'tank' is an engineer in this case, which is not the typical hero in that setting)
However, mechanically you see it pretty clearly.
The DPS person is the one doing almost all the damage. They are the one doing the actual 'work', and they are what end up taking down the bad guys. (and thus potentially taking all the credit, if they are jerks).
The tank's job isn't to defeat anyone. Rather, it's to distract the enemy, and draw their fire. They are there to protect the others, and keep the more fragile team members alive, by virtue of taking the hits for them,
The support... heals and buffs, and generally keeping everyone else alive, and making what they do vastly more effective.
The support especially rarely gets much of the credit for anything. But if you look at this model, I would argue you could still build a viable game around being the support. As long as the 'hero' ai is competent enough to avoid just being a frustrating, useless thing.
Could be interesting, actually...
On topic, I would say the nature of a video game protagonist often leads to them being a mary sue by design. Even if story-wise the character isn't, by virtue of their role in the world, how the actions of a player look in context, and even the fact that, in a quite literal sense, a game world revolves entirely around it's players...
A player character can't help but be a mary sue no matter how the character itself is portrayed.
To portray them as anything else is in fact just going to create various degrees of narrative dissonance, and make the gameplay and story seem more and more disjointed.