Best advice I got about my all time present self criticism was:“Imagine the self criticism or self hate in the voice of someone you don’t like and don’t respect. Donald Trump for example.”
It makes the voice in my head that says:“You are a worthless piece of shit.” entertaining at least.
It depends, mostly on yourself and how you feel about it. Most artists have shown some form of shitty behaviour - Dave Grohl cheated on his wife for example. Is that enough to stop listening to his music? Probably not. Kanye West released a song called “Heil Hitler”…is that enough? Probably, but does that also count for his older songs? You decide. No one else can.