The leftist cooks recently made a video about Neil Gaiman and how to deal with the realization that one of your favorite artists is an abusive piece of shit. In typical leftist cooks fashion, the vid is long and very meandering and goes off on costume change heavy tangents about celebrity worship and parasociality, the cultural industry under capitalism, DIY communities and what death of the author originally meant before it became an excuse for "i'm still throwing money at my problematic fave", but it has some honest takes about the anguish you feel as a morally repulsed fan.

https://www.youtube.com/watch?v=T31HKuabyMA

I never got into Gaiman's orginal works, but i saw and kinda enjoyed some of the adaptations and like you or the cooks, i don't think i can ever come back to this stuff. Death of the author was originally designed as an approach to literary theory that compensated for the fact philologists couldn't access university libraries full of letters and diaries from the author, historic works on their era and other material to read a text within a framework that centered authorial intent. It was never meant as a way to easily disavow creators while still consuming media that's full of stuff that suddenly appears in a new, dreadful light after the allegations have been made public, it was driven by a material necessity to get away from always hovering around the question "what did the author mean by this?" and center the recipient instead. Now it has become a way of indulging in cynical indifference and intellectual lazyness.