Depends on the context surrounding the art and whether enjoying said art is directly funding the artist's problematic views. Someone enjoying a Lovecraft story isn't doing shit for him. No one's views on race are going to change from stumbling upon his cat's name either. Whereas someone buying a Harry Potter product is directly funding trans people's deaths. However, buying a Harry Potter book secondhand is supporting local business (though I will still judge you for shitty taste and for promoting the franchise)

Context matters a lot.