Four words:
Miles Davis; Art Pepper.
I guess we (not you and I; people in general) are just that complex. Art Pepper did some horrendous things, especially to women, but he turned out some absolutely beautiful music. How does that even work? (I’ll grant him this much, the dude was candid about his misdeeds.)
I’d have a much, much smaller CD collection, if I were to thin it out based on the artists’ behavior.
ETA: That said, I don’t have much use for Scott Adams.