It's sad that the head of the CIA needs to resign because of a discrepancy in his private life. By all accounts, General Petraeus is amazing at what he does.
My Dad proposed to my Mom on their first date, and have been happily married ever since. I think it is disgusting what General Petraeus did to his Wife. But if he's the best person to lead the CIA and keep our country safe, I want him in that position.
I was in Germany just before the 2008 Election. One night, I struck up a conversation with an elderly couple at a restaurant. A few beers later they went on a rant about how Americans feel entitled to judge the personal lives of their public servants. I sympathize with their sentiment: "Clinton was great, stay out of his bedroom."