The Gary Jules cover of Mad World, for the Donnie Darko soundtrack.

Similarly, the original song by Tears for Fears sounds really upbeat and happy, but you'd never know it was a sad song unless you paid attention to the lyrics. I love both versions!