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.