It really depends for me; If it’s a YouTuber, or Author I’ll stop consuming their content if the offence has solid evidence and it’s something I consider actually bad. Books, podcasts and YouTube videos are too closely tied to the creator for death of the author to apply.
For tv shows, movies etc unless it was revealed everyone in the cast is horrible. There’s just too many people to disregard all their work because of one person. There’s too much that goes into production to apply it all to one person, it’s honestly insulting to disregard all their work because of one bad apple.
Cancel culture is nonsense, so many are far too trigger happy; When they actually target an actual horrible person they rarely do anything to help the situation (the only situation I can think actually help was the daddyO5 or whatever channel cancellation off the top of my head), before moving on to the next hot topic. How every other day someone is being cancelled for being into kids, maybe instead of hassling the person for a week then moving on; Try a different tactic to get these creeps off platforms because clearly it isn’t working . So often it’s getting off on their being morally.
It’s important to cover situations, but at the same time maybe try to get things handled behind the scenes before screaming about it(and get people that can actually do something about it involved); If their attacked first it’s easier for them to gain sympathy and lump themselves in with the actual falsely accused, or just wait till the mob gets bored (Like figure out a way to actually stop creeps and criminals from continuing their actions first)