Talking about the Vanilla Sky soundtrack, here's a great example of a "nearly perfect" song. I'm not sure where the problem lies exactly, but it's just missing that extra something that would make it one for the ages. (My instincts tell me it's the chorus and some sloppy lyrics in the middle...) Still, well worth a listen:
NOTE: Yes, I realise that these clips are not from Vanilla Sky. They're from À la folie... pas du tout (He loves me... he loves me not). However, it was about the only video that I could find on YouTube that had the correct version of the song, which didn't involve tortured little emo sayings flashing across the screen.