It's better not to.

The work they wrote, and what they left behind is more important.

A lot of times it comes off that book fans seem to expect their fave authors to be paragons of virtue, and can be disappointed when they find out the TRUTH, or become very defensive (on behalf of a dead author) when others tell them that their fave media creator is actually a terrible human being.

Others find out that their fave authors, or artists, or filmmakers do what's generally considered immoral or harmful or incredibly racist/sexist things and even jump through hoops to JUSTIFY that. Like pulling anecdotes out of a hat: "Well XXXXX did that too and he's a great [whatever]." or "YYYYY did this and he's not constrained by traditional morality." So that leaves us to wonder about these defenders, "Well, if ZZZZZ doing that is OK with you because he's a great [occupation], what does that say about YOU? You'd do the same thing?"

In the end, it's up to individuals to decide whether they want to appreciate the work and ignore the moral failings of the creator, or to dump the works in the trash and not consume any more media because the creator had stepped WAY over the line. Personal and individual decision and I'd respect it either way.

What's not cool is "cancelling" or intimidating fans, reviewers, or buyers of a work or a derivative work and accusing them of the same sins that the author might have committed, and supporting the author's un-PC thoughts about current social issues. If you don't personally want to support AuthorX because of their stance on certain issues, then don't buy it. Just don't jump down the throats of people who do want to buy it. (ahem. >!Hogwart's Legacy Game!<)