Shadowrun: Hong Kong Final Boss

Where a bald elf with a minigun thoroughly pulverizes a giant demon lady

I don't really have much to say about Qian Ya. She's a good addition plotwise and makes for an intense finale, but the fight itself is... pretty underwhelming. The enemies simply don't do enough damage or have enough health to seriously threaten you if you've been playing through all the missions (this is on Normal difficulty mind you). The gimmick in the first two phases of the fight is that she's impossible to damage if her fire shields are up (first phase) and heals really quickly if her allies are alive (second phase). The only potentially challenging part is if a player comes into this mission with crappy weapons and has a difficult time breaking through the boss's boosted armor (second phase).

Skip to @12:20 if you just want to see her final phase die in ~5 seconds. Also- accepting Qian Ya's offer forces you to kill Raymond and all of your companions (except Racter, who in typical psychopath supervillain-y form believes this can advance his goals of evolving the human race)