And then there's the Herald of Andraste in DA: Inquisition who has god-like powers. Rescued by Andraste herself in the beginning, and now has the mark on her hand that can seal rifts, and even the breach itself. This isn't a spoiler. It's only act 1. But wait! There's more but I won't go into that. You'll have to go to the DA: Inquisition forums or play the game!
Skyrim: You get to be the Dragonborn with godlike powers with your Thum! And if you don't have enough, your can sure craft your way to them.
Oblivion: Do enough of the Daedric Quests and you're a god. Hell, do the last DLC and you become a Daedric God. At least the game doesn't pretend, and I crafted armor such that I didn't have to even swing a sword. Hell I was doing damage to Mehrunes Dagon when he was attacking me, and taking almost no damage myself due to my armor reflecting 95% damage.
Then there was Hawke. I loved Hawke. She was my favorite video game champion. Dragon Age 2. Perhaps the second most hated Bioware game after ME3 and not because of the ending although that played a part in it. DA2 hated because of the reused areas and lack of depth. ME1 reused areas a lot. DA2 was about political intrigue in the City of Kirkwall. Oh, yeah,
But it was the only Bioware game I'd ever played that wasn't about saving the bloody world from some big bad thing that was going to destroy it. The character felt human, not like a god. She wasn't over the top. She was a person and wasn't making life changing decisions for everyone. DA2 was a kick in the teeth to players who wanted the empowerment fantasy, and I think that was one of the reasons it wasn't as well received. And the champion had to run into hiding in the end. I loved the story.
Why do I need to go out and save the bloody world all the time. Blah blah blah.
I'd like to see more characters like Hawke. But I guess the reason we see the empowerment fantasies is that people are not getting empowered in real life. We get stuck in crap jobs where we're pretty powerless, and the games give us a place to do sh*t we'd never do in real life, because let's face it. If we had to play a video game about real life it would be boring as hell. I'm a sucker for cinematic sh*t, too. I love RPGs with the cinematic sh*t in them, and characters that are larger than life. I love the character customization screens, and the ability to play pretty much any way you want. So I'd err on the side of the empowerment fantasy, but what is important is that the writers need to disguise the choices better.
Example: Don't put things like the fate of the quarians or the geth in the hands of the player. That's way too much. One other option should have been presented aside from peace. If you had not overwritten the Heretics in ME2, Xen's solution, control of the Geth by the Quarians should have been an option. "Return of the Geth to their true masters: the Quarian race." + 300 Geth War Assets, and have this available to players for whom peace is not possible.
But in the end of ME3, there were three things that happened, and this is where it went wrong: 1) we learned in the last five minutes that everything we had learned over 140 hours was wrong, and that there was no conflict, only a harvest. 2) the reapers were saving organic life from itself making us the bad guy for fighting against them. 3) we were told that their solution wouldn't work any more and we would have to choose a new solution for the galaxy among the three they presented otherwise they would continue with their old solution. The solutions were pretty stupid, basically pick a color, and left many with a hollow feeling afterward. Each ending had its own set amount of hubris. No one should have that much power.
That was so over-the-top that it completely broke the suspension of disbelief. As far as your character was concerned they were identical: you died, the relays exploded, and the Normandy crashed in different colors. I hope we never see another ending like this.