Overcoming odds means that more often than not, you don't beat the odds... and the PC dies. You're rooting for mostly PC death. Does that feel heroic? To have the character you've brought along for 200 hours of play suddenly - go?...For me, a heroic story has nothing to do with how powerful a PC is, but what happens in that story. In fact, for me it feels more heroic when the actions in the story have overcome greater odds to achieve said actions. I.e., when you're already powerful, doing a powerful thing doesn't feel so special. But when you start out as pretty much a normal person, and have all these things stacked against you, and you still succeed? That to me is heroic. Having a PC survive to level 10 in AD&D felt a lot more heroic and accomplished than having a 5e PC make it to level 10.
If you're playing a video game style campaign and you just have another PC of equivalent power walk into the combat, you're not going to be too bothered. If you built a PC and crafted a good back story with continuing character development... it hurts. That is not fun.