Surprisingly few, actually. Most games are too easy (Assassin's Creed, DX:HR, Batman, Crysis) or too clunky (Dark Souls).
A couple of examples come to mind though:
- There's this one part in Mirror's Edge, a multi-story foyer full of enemies, just after you snipe the prison van. It's possible to just run through it, but it can be extremely satisfying if you try to take everyone out.
Vault a railing, slide over a bench, land right in front of a cop. Knee him in the face, kick his buddy in the shins and disarm him from behind before he recovers. Throw the gun away and sprint down the stairs. Leap from staircase, landing on SWAT officer's head. Disarm second officer by sweeping out his legs, snatching his shotgun and smacking him with the butt as he goes down. Discard shotgun, vault railing and cushion the fall by landing on a machine gunner. Turn, charge, use a nearby bench as a springboard and take out final enemy with a flying kick. Saunter out the door like a badass. All in first person. Usually takes me about 15 tries.
- Anyone ever play Oni? Old game, not well known. Made by Bungie just before Halo became a thing.
Charge a cluster of enemies, focusing on the one carrying a weapon. Front kicking disarm - kick him the face, force him to the ground, twist the weapon from his hand and empty magazine into his chest in one smooth movement. Charge second opponent, arm around his neck and swing yourself around, breaking neck and hitting third opponent with feet in the process, knocking him over. Hit last standing opponent with flurry of kicks, finish with charging leg throw. As downed enemy recovers, kick him in the nuts, jink behind him and break his back. Good times.
