The question cannot be answered with general terms and rules because it would depend on
(1)who and what are the current other options
and
(2)how much of his personal faults are being kept personal and how much of his personal faults and views is he trying to force on everyone else
In the memory of recently departed David Dinkins I will say that I would a prefer a corrupt and somewhat anti-semitic person who strongly values law and order over a nice guy like David Dinkins for mayor any day. The Crown Heights pogrom would not have happened had the former been mayor. It did happen with the latter.