Joe Biden stole my cookies once; I'd still vote for him. I also bro'd out with Lindsey Graham for a week, and I'd never consider him at the ballot box.
I see your point: you want someone with integrity, who leads with conviction, and who can be trusted to make good on campaign promises. On the other hand, that sort of thing can be empirically examined, considering Hillary's Senate record. (For instance, Donald Trump has no voting record; he could be part of Bernie Sanders' long con to disrupt the Republican party at this point.) Hillary's uncharismatic and wooden and has trouble connecting to the average American. I think talking to her one on one would be painful, whereas I could at least shoot the shit with Obama for an hour talking about basketball.
... but that doesn't actually matter in governing. Not much, anyway. The charisma needed to broker deals in Congress isn't the kind that's, I don't know, needed to participate in a pie baking contest at the Pawnee State Fair.