As much as Foley needed to be removed from office, it is also important, as you have said, to remember the Democrats are trying to exploit Foley's behavior for political gain.
The Democrats have had their share of misbehavior, especially that of der Schlickmeister, William Judas Clinton. The reason the Democrats don't seem to think Clinton's misbehavior was reprehensible, is because Clinton is a Democrat.
Said another way, according to the Democrats, (and I'm sorry to say, Christopher Shays), a rapist is a fit president.
I think the clintons' failure to confront terrorism for 8 years... and their reasons for not doing so... proves this to be a false premise.