Would you vote for a candidate who espouses different values in their personal life than they do in their politics?

I am a bit confused as to why voters would vote for Newt Gingrich when he has a history of cheating on his wives, one who had cancer while he did it, and yet all the while he supposedly has conservative values (also known as “family values”).

I have friends who are staunch Republicans who feel the same way.

Is it just me? Does it bother you if a presidential candidate is apparently a hypocrite? Would you vote for that person?