I guess it depends for me. I love Roald Dahl, both his children’s and his adult’s work, even though he was a virulent antisemite (even the museum dedicated to him comes right out and says it). My dad, who was super-sensitive to that stuff, was okay reading his books to me when I was a kid despite that.
And I think the reason why is that he didn’t let his beliefs leak into his work. I can’t look back at any of his works that I have read and see any hatred of Jews.
On the other hand, there’s someone like Woody Allen (Jewish connection not intended here) who you can see his awful shit in his movies. He’s literally dating a high school student in his film Manhattan. And he treats her like shit and basically gets away with it too.
I can’t watch Woody Allen movies anymore.
For me, Salvador Dali’s work transformed from fascinating into kitsch when I learned he was a fascist.