There has been the rare occasion for me where a music video had its intended effect — it captured my interest enough to make me want to explore a band that I hadn't previously.
"Salvation" by The Cranberries had that effect on me.
But I've never had the opposite happen where I was turned off from a song by a band I already liked, because I thought the video sucked.