Where have all the Hollywood heroes gone?

I know I'm going to sound like everybody's father when I say this. What ever happened to tv shows and movies where there really was a good guy? These days the Hollywood landscape is dotted with heroes with problems. Where are the tv shows that don't feel the need to show the protagonist's failures, or at least show him not succumbing to them? Why does the hero always take the drink? Why does the sexual tension always result in the affair? These days we even have mobsters and serial killers as protagonists. Interesting tv, true - otherwise nobody would be watching and the shows would fail.

Could a show survive if it didn't try to make us identify with the hero because he's got a problem? Would we applaud the hero's victory over his personal demons or would that just distance him from us and make the show less believable?

I'm not talking about shows that are overtly preachy. Shows that center on a minister's family or that feel a bit too folksy aren't going to grab the attention of a wide enough audience to make a difference. It's got to be good tv to begin with. But must it delve into the hero's faults? If it has to, and it shows him being triumphant over them, are we too far gone to buy into that? I hope not.