All I can think off at the top of my head, is "Viva Forever" by The Spice Girls. Now, I know that very few people would call anything by the Spice Girls a "great song" (though, this doesn't really sound like the rest of their songs if I'm honest), but I really like the point of the lyrics, and it can be pretty emotional if you set your mind in the right way, but the stupid video with the faires... I can't take it seriously at all, they just don't look right.

To be honest, if a song means something to me personally ("Viva Forever" doesn't mean anything to me personally, I just like the song) I tend to be reluctant to watch the music video sometimes. I know they can be good, but sometimes it's just good to visualize what the song means to me...