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.
@InUnfunky
Then we veer off into how many men you start to find out were secretly sexual abusers. The past few years were pretty disturbing. And heartbreaking too. I always want to believe the best in people, but practical me knows that just isn't possible.
@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.