u/Dismal-Ad6476

Yor Forger(Spy X Family) is a master assassin and one of the deadliest people on the planet, but has trouble with everything else and come across as a clumsy but well-meaning mother

El Fuerte(Street Fighter) is a master chef as long as he's making mexican food, anything else is inedible

Ingo Montoya(The Princess Bride) as cool as he is, but after his father was murdered by the six fingered man who claimed to be a master swordsman, Inigo trained obsessively to become a great master and to be able to defeat the six fingered man. However, Inigo put virtually no effort into learning anything except swordsmanship, so while he's one of the greatest living swordsmen, he's hopeless at pretty much anything else, including basic math. Without someone like Vizzini to do the thinking for him, Inigo is clueless about how to function in society. The fact that his Ultimate Blacksmith father was a half-mad recluse before being killed is another reason Inigo lacks a lot of basic skills and knowledge

Kazuma's Party(Konosuba) Kazuma's stats are average with the exception of having a high luck stat and can copy skills at the cost of sub-par skill score growth, Aqua is the party's White Mage but has exorcism which only works for the undead and water magic that ranges from neat party tricks to overly massive floods, Megumin has only one spell, Explosion, which is a powerful spell but the only spell she knows and it drains her energy every time she uses it, and last but not least Darkness a powerful tank capable of shattering rocks like nothing but a lousy swordswoman incapable of hitting anything even stationary targets

This is Texas Red (Big Iron) vs Liberty Valance(The Man Who Shot Liberty Valance) btw