It depends upon the context, the time of the comments/actions in question versus release date of artistic material, and the artists' intent/history of behavior.
An easy ex. is Skrewdriver, the UK white power band. Ruled out right away, lol. Nugent would be next for any number of reasons.
Clapton somehow got a pass on his remarks (which started Rock Against Racism) until his 'rona bs, which Van joined in on. Or Roger Waters with his Putin views.
It's an uneasy continuum.
It's USUALLY a matter of degree and not kind...usually. Again, see Nugent, Skrewdriver, etc. Those are easy and clear cut extremes.
Artists, scientists, pols are human and say/do stupid shit on varying levels of stupidity as we know. "Redeeming social value" cliche has play here, if any is merited.
More exs -- many early enviros were racist and xenophobic. Our intel post-WW2 depended on Nazi scientists. Tradeoffs are 🤬
Less mortal? See JK Rowling, Chappelle, etc.
@InUnfunky
Chappelle is a good example.
Pretty controversial for plenty.
Redeeming social value indeed. This seems to be the problem. What is considered to hold social vaue now. Not static.