Kratos, after playing God of War, while he's got a lot of problems and nightmares, the powers he weilds means that no bully would EVER want to pick on a guy who's killed 7 Gods/Goddesses and counting (I haven't beaten the game yet). Plus, he's so virile that he can make love time after time without any waiting unlike us normal men. Plus, he makes love so well that he turn people on by just having them watch (plus the power to pleasure a Goddess who has sex all the time is pretty cool)
He's what every man wishes he was, powerful and good at sex, though he has his flaws, he's just crazy super
If not him, then (and this counts BECAUSE there are games) I'd want to be Sokka from Avatar. I know it's based off the Anime, but hey, it's quirky, funny, and a skilled warrior who starts off average and becomes probably a better fighter than Aang, Zuko, Toph or Katara BECAUSE he doesn't have the power to bend, and can still beat the same people without bending.