Jimmy Carter was one of the worst Presidents we’ve had in the last hundred years... but he was ‘faithful’ other than ‘lusting in his heart’. He had a good heart but could not run the country - other than into the ground.
If you want close to perfection then focus on finding the most sexually moral minister for your church you can find.
If you want a guy whose wife can’t trust him…feel free.
He is old. He is immoral. And he cares about himself more than anything or anybody.