Anyway, way back in the day, I was a Gaiman fan, of sorts - and if anything, more a fan of other fans of his, as in the days before being a nerd was cool, shared nerdy books helped you connect with people like you, and NG facilitated this - he had a forum on his website, he attended events like (almost) a normal person, etc etc. He had bags of charm, and really spent time on cultivating his fan base. The lines for book signings were so very long because he'd doodle in your books, use two different pens, etc. It was easy to be charmed, and to connect with other Gaiman fans who were also charmed. I didn't like everything he wrote, far from it (Neverwhere was pedestrian at best, and Ocean a total bore) but I did really enjoy some, and loved Good Omens.
But, but, but. As time went on he really seemed to buy more and more into his own fairly unpleasant self-image of the Rock Star Author, someone who wasn't bound by the trite rules of conventionality that us normies lived by, and I drifted away. He left his wife (and the mother of his now-adult kids), and threw himself into the train-wreck open marriage with AP. (Though he'd allegedly tell female fans that he was in an open marriage with his first wife, too, which I bet she didn't know about.) Rumours of women in publishing warning each other about him at events, the flight from NZ, AP and his most recent child during covid, the endless "wise" (read: trite and usually sexist) pronouncements on the social justice issues of the day, it all just got grimmer and grimmer.
Tl;Dr as an ex-fan, I'm totally unsurprised by these allegations, and believe every word.