He resigned, so assuming he made his own decision maybe he felt like he couldn't do the job while hell was breaking loose in his personal life. But I agree with your larger point: I don't care who boinks who...no idea why peoples' sex lives continue to be news stories. The percentage of sexually deviant or unfaithful public servants is probably very close to the percentage of sexually deviant or unfaithful people in society at large.
Its ridiculous that it is an issue for anyone but their spouse. BobD's argument about if you would cheat on your spouse you would also commit treason is garbage, with all due respect to him. Lots of people cheat; lots of people don't commit treason. The two things aren't in any way related.
I think Petraeus will be remembered as a fine public servant and an American hero, and this will be a footnote in his biography. Ultimately, this is a big deal only to him, his wife, Paula Broadwell and her husband, and whatever children they all have among them. Nobody else should care.
While my personal views inform me that those who cheat have an issue...I think it needs to be more than my gut.
I look at it like this...when you get a security clearance the want to know a couple things.
Credit History....ie are you someone who puts themselves in a position to be bribed, manipulated with Money
Mental History...ie are you a person who lacks the stability to understand the import of the information you may have, and toprotect it accordingly
Chemical dependency...can you become vulnerable...can the manipulation be done with substance, or will you render yourself unstable
Yea they ask your 3rd grade teachers dog about you...but those are kinda the big 3 if you of course don't have a criminal record.
I don't think the process of infidelity renders you more or less likely to be "turned". I think the prospect of getting caught, and the perceptions of others is huge motivation to cover it up...and therein is the vulnerability...it makes infidelity lead to desperate decisions. So when a guy owns it...I'm less likely to question him, and his ability to do the job. It tells me he isn't willing to be put in a position to be manipulated. Just my take.
As I mentioned earlier, my beliefs inform me he needs to go away for awhile and get it together...resignation was honorable in that he showed he cares more about the CIA. He showed integrity because he owned it. After things calmed down I would never bat an eye at putting the General in a position of trust in the future.