Well, there's a few types than generally appeal to me.
There's the extraordinary eccentric: great detectives, genius types, very talented individuals. These types tend to turn up in serial form... tv shows, multiple books or films. They are most notable for having gifts appreciated so much by others than their notable, sometimes almost crippling flaws are either overlooked or at least pardoned, written off as the handicap to balance the gift. In short, they are valued despite their failings. I tend to be very jealous of that. Eg: Doctor Who, Monk, Hercule Poirot, Sherlock Holmes.
The alternative Cinderella: Someone no one thought much of, someone who was written off as a bad job, who was ordinary or even repulsive, who had something about them that everyone, including the person in question, took as worthlessness... who then is given (or even better, who discovers) about himself or herself something so wondrous, so special, that it shames the very idea that this person could be anything but extraordinary. Often called "The Chosen One." I know there's years of pain behind my love of this type. eg: Bastien (The Neverending Story), Harry Potter, King Arthur
The brave, lucky idiot: someone who plunges forward determined to do the right thing, risking life and limb and abject humiliation and copes and still ends up coming out a hero despite a sometime deficiency of really brilliant thinking on his part... usually has the aid of wiser, less active people. This type's raw courage and usual selflessness and loyalty to those he loves is balanced by his tendency to make a lot of mistakes and suffer huge amounts of pain in the process. eg: Flik (A Bug's Life), Marty McFly, Guybrush Threepwood, Spider-Man (again, sometimes they do stupid things, even if they're not stupid)
There's also the Frank Capra hero... I think that's the best description for that one.
_________________
"Pack up my head, I'm goin' to Paris!" - P.W.
The world loves diversity... as long as it's pretty, makes them look smart and doesn't put them out in any way.
There's the road, and the road less traveled, and then there's MY road.