I've been pondering this all day, and it's a tough question. If the artist's hatred or bias is reflected directly in their work, then that's clearly a problem. Otherwise it depends a bit more on the context, the nature of the issue, the nature and quality of the work, etc. A few examples, considering only the area of anti-Semitism:
Mel Gibson: I don't see any reason to watch his films given his prolonged an unapologetic anti-Semitism (some of which comes through in his work) and misogyny. If he were as good a film director as Alfred Hitchcock, that might be another story.
Sally Rooney: I was troubled by her refusal to have her books translated into Hebrew as a protest against Israel. The fact that she didn't have concerns about Saudi Arabia, China, or any number of other countries suggests to me that the issue goes beyond political protest. I'm a big reader and bookstore browser, but I've chosen not to purchase or read her work. There are a lot of other good books in the world. But again, if she were as good as George Eliot, I might feel otherwise.
Kanye: He's batshit crazy and I'll have nothing to do with him.
Classic writers: Charles Dickens, George Eliot, Anthony Trollope, TS Eliot and Ezra Pound all had aspects of either their work or their other writings that could fairly be called anti-Semitic. For some, like Dickens and Eliot, they had later recognition of that fact and were apologetic in later works. For others, not so much. I love and read all of these writers except Pound.
