The two protagonists of Big Trouble in Little China are Wang Chi and Jack Burton. Wang is a fairly straightforward martial artist. Jack is what most roleplayers would call a rogue-type build that focus on non-combat skills.
Every time Jack and Wang get into a combat situation Jack turns into a bumbling oaf while kicks ass. By the same token, when non-combat challenges such as scaling a scaffold, getting out of tied ropes, or catching a knife, Jack is the star of the show while Wang is out of his element.
What makes it work is that Jack and Wang can't succeed without each other. Without Wang, Jack gets punched or shot to death by a random mook. Without Jack, Wang gets thrown into a torture chamber and killed.
It's a nice outside look at how a roleplaying game dynamic should work.