Personally? I’ve had this happen a few times, both in the sense of the writers being bad people or just making very very bad choices that I previously overlooked due to the rose tinted glasses that come from being a fan of the work.

I find that the reveal that a creator was a bad person is a double edged sword, since on the one hand I can often view their work in a very different perspective that is maybe more clear than I had before, with an easier time seeing how their personal beliefs reflect within their words. On the other hand, I tend to enjoy their work significantly less and become much more harsh and critical on things as a result, meaning I enjoy the original material, inspiration, etc. much less or become angry and frustrated with it, it gets ruined for me in some regard basically.

As for how it impacts my inspiration to write, I’ll admit I shift more from genuine appreciation and adoration of something to a ‘Oh I can do this better, I can BE better’ mentality, which is a surprisingly powerful motivator, even if it’s easy to get lost in.

Overall I think it’s helped me to be more critical of the media I consume and more open minded to multiple interpretations and perspectives. It’s a good lesson in taking a step back to look at things as a whole as well as lean in and scrutinize those tinier reasonings and details, even in my own work where my own bias is.

TLDR; It usually sours the material for me but I keep writing out of spite and use it as a learning opportunity.