For contradictory music/lyrics, you can’t go past ‘Pumped Up Kicks’ by Foster The People.
Very happy, upbeat song, used in a lot of commercials but when you listen to the lyrics…
‘All the other kids with the pumped up kicks
You’d better run, better run, outrun my gun
All the other kids with the pumped up kicks
You’d better run, better run, faster than my bullet’
The biggest music/lyrics mismatch to me will always be “Excitable Boy” by Warren Zevon, a bouncy little number in which a young man rapes and murders his prom date, later digging up her grave and building a cage with her bones.
For the sort of mismatch the OP describes, it’s probably hard to beat Falkenbach–there are too many examples to bother with listing. I give him a pass 'cause he’s Icelandic and English is presumably not his first language.
For the other type, Bad Religion’s Better Off Dead comes to mind. The cover by Anathema matches lyric to melody much better.
You sure that’s “Olympus”? Heard that song yesterday, and I’m sure there’s an “r” sound in the spot in question. I tend to hear “an empress” or “a lepress” (yes, I’m aware the latter is a bit nonsensical ) where you’re saying “Olympus”.
I have no idea what the definitive lyrics are but I also originally heard “lepress” and then settled on “empress”.
Olympus makes no sense in my mind because it’s already a real geographic location. It’d be like describing the Mojave desert as “stretching on like the Sahara”. Even if Olympus is the correct word, I shall continue to sing it my way since I obviously know better than Toto.
In classical times, the Greeks had nine Muses – goddesses of literature, science and the arts: Euterpe, the Muse of song; Calliope, the Muse of epic poetry; Melpomene, the Muse of tragedy; and so on.
It seems there was also a little-regarded tenth member of that group: Elemenope, the Muse of tortured prosody.
Never very popular, these days she is only remembered because of her appearance in the “Alphabet Song”.