Kind of hard to reconcile success in mechanical terms with a downward spiral in plot, no? Unless you're talking about the grand scheme of things, not the runs you go on. Which would mean depressing footnotes to your personal success story or something, idk if that's satisfying.
That's the crux of the issue, and I'd add another complicating factor: kind of hard to reconcile success
and progression (which is an expectation for RPGs) with a downward spiral in the plot, no? You're right to question wether that'd be satisfying. If there's one cautionary tale about having the PC live in a shitty world where they can't do anything really it's Dragon Age 2. Mages and Templars hate each other, and they destroy the city in the end. You can only survive.
I think the earlier post about Dragonfall made a lot of my points for me. Unlike what I said in the OP you do lose a lot through Dragonfall's story, even as you do achieve your objectives in the end.
I'm also reminded of an Old Codex post, which proposed a game about travellers in an 'europen black plague' scenario. Leveling up would be mandatory and would actually be levelling down, as you lose your physical faculties over time in your journey.
That is a rather extreme scenario, so think of roguelites where the objective is to protect some village from inevitable destruction. You still win, sorta, because you are ever more successful in your last stands. Can that be done in a Shadowrun plot? Can you have a game where you're a runner who's pretty much fated to die from psychological trauma and physical damage, making money and attaining luxury on the way? I dunno, but it's just food for thought.
"Power fantasy" is a bit of a stretch. Both Hong Kong and Dragonfall make it pretty clear that, despite all of your actions and all your effort and your hard-won "accomplishments", you really don't matter one bit in the grand scheme of things*.
I can see where you're coming from. Back in Hong Kong I expected that we'd have a convo with
but then I realized that she's too high up and her comeuppance must come from her peers. Not us mere runners. The expanded story only adds to your point. Still do you suppose this:
In all three Shadowrun games we play people who thrive in the shadows, and who make the best of them at every turn. Sure, we are often broke, chased by the police, or worse. However our trajectories always feel ascendant. We never fall into a corporate blacksite, we are never betrayed by the people who really matter, we never lose friends or comrades, we never lose much of anything really.
Could be called something like a 'bad-ass fantasy in a world that fucks up normies as a rule'? I dunno I think power fantasy is good enough, even if the power fantasy isn't absolute. Must I be a God to be in a power fantasy?