Pretending to be, playing at being, and fantasizing about being a hero who is merely good at killing things and not moreover morally heroic is about the saddest, vainest, and least productive pursuit I can imagine. It is a certain amount of onanistic behavior. The phrase stroking ones ego comes to mind. If that is all we are doing, then we really are the pathetic losers popular culture makes us out to be. If we aren't actually tackling serious questions, creating worthwhile stories, learning history, math, cartography and anything else we can, improving social skills otherwise latent in typical nerds, and otherwise being productive, then we are greatly overindulging a childish pasttime and need to find something else to do with ourselves. Knitting. Jogging. Board games. Anything.
I'm reminded of the X-Files episode where they say they 'didn't spend all those years playing Dungeons and Dragons and not learn a little something about courage'. That's either pathetic or wise, I've never been certain which. Maybe it's both. Sometimes irony can work on several levels. Let's just say that I would certainly hope that you couldn't play Dungeons and Dragons and not know what a hero was, even if you manifestly weren't one.
I'm not normally one to come down on the side of 'narrativism', but sheesh, if you are above the age of 15, either do something interesting with your game or go play something like Chess or Counterstrike. Spend your skill points on something for crying out loud.