My favorite (or perhaps most regrettable) example of this is Albert Einstein.

Obviously brilliant, but a real piece of shit when it came to women and fatherhood.

Still, I can appreciate his scientific work nonetheless.

Is that really true? Young children perhaps. IME most folks learn that people are complicated at least by adolescence once they realize their parents are imperfect.

Of course there is the ever present temptation to resort to tribalism, which is pretty binary: in or out.