Every game is power fantasy.
Most of them are, in some sense, including Shadowrun. Video games narratives tend to be about exercising agency you lack in real life. That's why I used the word *really.*
However, there's a huge world of difference between being a Runner who survives corporate machinations and pulls it off by the seat of his pants and being:
The Bhaalspawn -- the quasi-deity, elf lover who inadvertedly saves lives on the city scale and becomes a "pseudo" celestrial Paragon or Arch Fiend
The Hero of Neverwiner -- probably the closest to being working Joe, still has more celebrity and glory than any Runner even after Nasher played down his role in saving the city.
The Hero of Undrentide/The Devil Slayer of Waterdeep -- an epic level Plane Walker who survives cities falling from the sky and charges headlong into armies of devils, and the devils are the ones who are afraid. Most epilogues suggest he too becomes a quasi-deity because of his accomplishments (an immortal who wanders the Planes doing acts of goodness or evil)
Revan -- nuff said
The future Emperor of the Jade Empire, greatest kung fu master ever and polygamist who marries the two hotter royal cousins
The Warden, the kingmaker, one man army, and diplomatic mastermind -- probably also military commander based on the Battle of Denerim
Commander Shepard -- the fact that he is a Specter who can kill anyone and go anywhere with full legal license doesn't even matter as the series goes on because Shepard is a cosmic force in his own right that can't be "judged by" or "receive authorization from" mere mortals
The Champion -- the Champion
The Inquisitor -- pretty much redundant to say more at this point, but he's a trans national legal authority with most of the abilities of the Warden and the authority to imprison anyone -- he moonlights as the Avatar of an elf goddess
In Bioware game the power fantasy furnishes the core narrative and everything in it, in the Shadowrun Trilogy the power fantasies are tastefully incorporated into a plot that empathizes the Runners are way over their head.