One of the things I love most about MacGyver (1985) is that we get a hero who gets to be bad at things sometimes. Little things, too: small, random human things.
He can’t cook. He hurts his hand when he punches people, and shuts his fingers in doors sometimes. He speaks a little of several languages, all with a terrible accent of which he is very conscious. He gets cranky when he’s tired. He hates heights. His home is a mess.
He’s a ridiculously talented agent with an incredibly impressive skillset but he never stops being human to be a hero. That man is going to save the world and then he is going to go home and make a terrible tofu casserole and it is exactly that combination that makes him one of my favorite characters of all time.
This is... well, it's not the only way to make a relatable hero, but it's a very good way! Not "relatable" as in "I could imagine chatting with them over Beverages at the Place To Hang Out" but "relatable" as in "oh, just like regular people, this character is quite good at their primary skillset but outside of that there's a good chance they're as useless as I am outside of mine."
I'm too old to get invested in characters who are perfectly competent at nearly everything in practically every physical and social situation. Give me characters who've got some dumbass in their makeup... just like I have.












