David Petraeus has resigned as head of the CIA after admitting to an extramarital affair.
He has stepped down to deal with the "personal and professional issues."
Link.
Personally, I am not interested in anyone's sex life. I do recognize that the possibility for blackmail may make this a special case with respect to public officials.