I mean, theres 3 categories for giving them a pass on their transgressions (as a fan, not legally or morally speaking) IMO.
-
The art/performance was just so far beyond good that you cant deny the cultural significance. E.g Michael Jackson, Elvis, Tupac.
-
You had a personal connection to the art before they did the shitty thing or before it came to light. (In my case: early Chris Brown, Kid Rock) They were big in my late teens and early 20s and I have positive memories associated with their songs. Not the percieved quality of the art.
-
They had their day in court, did their time and time has passed. E.g Mark Wahlberg, I dont know the guy, I dont know if he is a good person or not these days. But the last documented occasion of him being a huge violent racist asshole is 1992... 32 years ago.