Modipheus Conan: Sword and Sorcery with focus on the sword. System involves a give and take with the GM in resources that makes actions easier at the cost of giving your gm "Doom" which they can use to drop in more enemies on a scene or take special actions. Progression is purely on the character and focuses on building up THEM instead of their equipment and gear. Great for a survival game.

This is going to sound weird, but White Wolf Street Fighter the RPG functions really well for any martial arts tournament game in any setting.

Righteous Blood and Ruthless Blades is a great system for Wuxia combat. Exalted has a similar feel but on a grander supernatural scale.

If you want something Brutal then Runequest Gloranthia is great. Bronze age stuff with a hugely diverse world and culture about it. I recommend the starter adventure of Yozarian's Bandit Ducks.

If you're playing an investigative game it's hard to recommend a better system than Call of Cthulhu. Regardless of using mythos stuff you can use pretty much any horror element you want.

If you want to try some campy horror you should try It came from the Late, Late, Late Show. An RPG where you play both actors and characters in a campy late night B movie. think "Attack of the Scuba Ninja Zombies on Bikini Beach" type of thing. One of the gimmicks is that if you don't like the way a scene turned out you can storm off the set and demand a rewrite with a successful fame roll.