Everyone is going to have their own position on this; for me, the answer is “it depends”. It depends on the nature and severity of the dislike or disagreement and the transgression that caused it, and also to some extent the degree to which the artist’s faults are or are not evident in the artistic work itself.
For example, if a person of reprehensible political views wrote a book opining about politics, that would be a non-starter for me. But if the same person composed beautiful music or produced beautiful paintings, I might be persuaded to overlook their politics.
One of the things that has irked me in recent years is all the hate directed against Woody Allen, including Hachette Group canceling the publication of his bio that they had already contracted, and Allen reportedly having to move his filmmaking to Europe where the cancel culture is less rampant and less vicious and trigger-happy. I’ve been an Allen fan for many years, and the man makes well-crafted movies that are often very funny and sometimes brilliant. I’m not going to stop watching them, or throw existing ones out of my collection, because of some allegation that was not just unproven, but for which investigation turned up no credible evidence, and which allegation furthermore came from an unreliable source that was motivated to damage Allen.
OTOH the things that Bill Cosby was convicted of, and served time for, were especially heinous. I’m just not comfortable listening to his old comedy routines (which I haven’t listened to in decades, anyway) or watching reruns of the Cosby Show, if anyone is still running such things.
Bill Maher is another one that deserves comment. I’ve heard some people say that they can’t stand him because of what strikes them as arrogant smugness. Others object to his silly views on vaccines, and to some extent, medicine in general, or to his occasional extremist guest. I find I can overlook the first part, and consider the second part as being more nuanced than he’s often given credit for, and instead often taken out of context and exaggerated by his haters. So, while I’m not quite as avid a fan as I used to be, I still watch his show and feel that those who don’t are missing out on what is often well-researched information, interesting guests, and witty discussions.
Every case is different, and every one of us makes our decision about it, but I maintain that those decisions should be fact-based and rational, not knee-jerk virtue signaling in what seems to have become a fashionable cancel culture, the kinds of things that have wrought major damage on Woody Allen and nearly so on Chris Hardwick, who survived allegations of abuse only because his network put time and money into investigating and defending him.
That said, there are certainly many individuals – some of whom were mentioned in this thread – that I would avoid because of the egregious offenses they committed, not to impress anyone, but simply because I find such people toxic on a very basic level.