It depends. For a movie, it probably doesn’t matter to me unless there was a really egregious transgression.

If i’m buying a painting to hang on my wall, am I going to think about the artist more than the piece when I see it? If so, that would ruin it for me and I wouldn’t enjoy the piece, so I wouldn’t buy it.

Of course, sometimes the controversy behind a work is the reason it’s appreciated – not the quality of the work.