Neil was on my list of like, five men I was like "PLEASE DON'T LET ME DOWN." I don't think I have anybody left on that list. Not that they all let me down, but there were so few I just don't want to admire anyone anymore. I'll never go back to Neil, but that's because it felt like a personal affront.
My line for consuming their work is if they're still a) actively making money off it and b) still actively bad people. There's a few writers who were outed as sleazy, disappeared, might write a TV episode or a novella once in a while and basically owned their banishment and went away. I don't hold them nearly in the contempt of folks who try to brush things off. And then you've got Joann who just invents new ways to be shitty every day. I think of how James Gunn got called out for some shitty statements from 18 years ago - you can become better over time if you say harmful things. Nobody's perfect, but you can choose to double down or be better.
Meanwhile, Lovecraft was a garbage human, but he's dead and his work is in the public domain. I'll still read his stuff sometimes because there's no ongoing harm.
I don't think humans are all irredeemable but it's the ones who tell you what they are and continue to do harm that I write off completely.
I reckon there's a lot of dead men who created characters in toy lines I love I wouldn't respect if they were still kicking, but they've shuffled off this mortal coil, so enjoying their work feels less dirty to me.