Can you separate the artist as a person from the music?
For example, I personally can't listen to Guns and Roses without immediately thinking "that Axl sure is an asshole", and that sours the entire experience.
To an extent I can, like Axl is a complicated one given his mental health issues. Nothing excuses his behaviour but he seems to have grown as a person and managed to somewhat control his shittier side.
But there's definitely a line. I can't really enjoy rammstein or die antwoord anymore
Die antwoord also adopted, abused and abandoned an albino (Edit: my mistake, he has hypohidrotic ectodermal dysplasia) child, Tokkie, who spoke out a few years ago. They're truly awful and Tokkie's documentary is worth watching.
Also Marilyn Manson has been evicted from my music library for sexual abuse. I have no interest in supporting known exploiters, and I can't listen to their music without thinking about how awful they are as people. No regrets, there's plenty more musicians out there worth my time.