I'm also in camp "it depends."
When someone writes a character who's kind of an ass, but you can appreciate that character as an accurate depiction of an jerk -- but then the creator reveals themselves to share a lot of that character's views, and to be kind of a jerk themselves, that can break trust in a story. Suddenly I don't know if this character will be examined fairly, or if all the bad things he's doing are just things the creator wants to do. The creator's worldview matters in a story, seeps into everything.
But then, I agree very much with punkarsenic that sometimes there is a piece of media that reflects its creator's worst flaws, and yet something in that piece of media still resonates with you and you love it anyway. One of my favourite books is The Fountainhead, even though I know Ayn Rand is, well, Ayn Rand. The Fountainhead itself has a lot of very troubling things in it. But it also put to words so many of my own experiences as an artist in a way that impacts me to this day; it doesn't matter what its creator was like. Nothing she could do would take away what it meant to me to read the scenes that stayed with me.
Does it really matter?
"Good" is already so subjective. Stories depend a lot on the perspective you bring to them -- whether they resonate with you or not. A story can be successful or unsuccessful, sure, if it's well-paced or poorly told -- but does it really matter whether it's "good" outside of your personal experience? What's the point of trying to isolate a story from the things that colour the way it would impact you?
There's something bitter in broccoli that some folks can taste, and others physically can't. So some people hate broccoli, and some people enjoy it, and it's all because of the subjective experience of their tongues. So who's right? Is the broccoli "good" and the folks with the bitter genes are just letting their own personal tastes colour the experience? Or is the broccoli "bad" and the folks without the bitter genes can't detect it, letting their own personal tastes colour the experience? Does it matter?
Ultimately, I think "good" vs "bad" is often sort of meaningless. "I liked it" or "I didn't like it" seems more honest for everyone; everyone's personal experience will colour how they see something.