I'm disappointed to see members mentioning not necessarily the most epic songs by a band, but rather the old, most popular hits that everyone knows by heart.
I must agree with OP concerning Deep Purple and Child in Time. I think that would be their high water mark. Let's see, what else...
Sway - Rolling Stones
November Spawned a Monster - Morrissey
Accidentally Like a Martyr - Warren Zevon
Precious - The Pretenders
I've Returned - Squeeze
Junkhead - Alice In Chains
Street Life - Roxy Music
It's Over - Level 42
Untogether - Lush
Adam and Eve - October Project
I could think of a million more, but these are the first to come to mind.