I have no ideas that he's perfect, but if your flaw is that you can't keep your affair secret then you're not really qualified to be the guy who runs the organization whose job is to keep and discover secrets. It's kinda of like recruiting a QB who can't throw past the line of scrimmage.
Having an affair doesn't disqualify you from ts clearance. Although if you lie while doing it.... Eisenhower, Clinton and Napoleon aren't great examples, Dulles is better.
An affair, by itself, likely shouldn't automatically disqualify someone. But in any given case an affair could result in the person being at risk of being manipulated, being bribed, etc, or could put classified information at risk of being disclosed. It doesn't seem as though any of these potential problems exist here. Which I why I don't understand why P resigned so quickly. Why not try to ride it out, like Clinton? Our attention span is so short, this would've been forgotten in a month or so.
The affair is just window dressing folks. That's not the substance, the meat of the reason why he is no longer the CIA Chief.
His secret affairs should be so secret that the woman/women he's having affairs with shouldn't even know they are in an affair.....he's supposed to be the king of secrets fer chrissakes.....sloppy.
Anyone with a security clearance working at any of the various defense companies caught in a similiar situation will lose their security clearance and hence their job. Even an entry level engineer. There is nothing special about Petraeus. The bar should actually be higher for him. This is a no brainer.