AGREED.
The only two heroes like that who are *kind of* interesting are Luke Skywalker and Harry Potter--in my humble opinion. They're dull, but very likable. Most other protagonists though are so boring that I wish they'd hurry up and leave the scene, so I could see the more interesting supporting characters.
For that reason, when I write stories, I don't actually like to have one chosen protagonist. Sure, I'll have one character who's "bigger," but the POV and heroics are divided between characters, when I write.