I was listening to the Temptations Can’t Get Next to You and realized, damn, those guys are POWERFUL.
There are two more stanzas like this. Altogether, the song has a list of powers fit for a deity.
The Who were content with Superman’s telescopic vision
While the Carpenters lived in a world of Disney animation
I can think of a few more songs like this. What do you have?
Freddie Mercury, as per Queen’s “Don’t Stop Me Now”:
So, he’s like the Human Torch (of the Fantastic Four), but capable of space travel, and lightspeed flight, as well. 
Superpower conferred upon the listener:
On a Clear Day, You Can See Forever
You Are My Sunshine
Fly Me to the Moon
Johnny Rivers and Willie Dixon boasted of many abilities: “Heal the sick, raise the dead
Make the little girls talk outta their head”. (Seventh Son)
R.E.M. was much more straightforward about it:
“I am woman, hear me roar”
Roaring is a superpower?
It’s mine!
In the same vein, Carly Simon says there’s a guy who — when he’s not with some underworld spy or the wife of a close friend — is where he should be all the time.
That’s maybe not a superpower; but it’s maybe better than a superpower.
White Zombie’s More Human than Human is essentially a list of Rob Zombie’s super powers.
Dr. Dre’s “Keep their Heads Ringin’”
Most of the super-power-est lyrics are NSFW, but here’s a SFW sample:
Harry Chapin, “Shooting Star”
The Phantom of the Opera:
Sing once again with me
Our strange duet
My power over you grows stronger yet
And though you turn from me to glance behind
The Phantom of the Opera is there
Inside your mind.
Donovan Leitch’s “Sunshine Superman”:
Superman or Green Lantern ain’t got a-nothin’ on me
I can make like a turtle and dive for your pearls in the sea
Oh, and pretty much all of Bruno Mars’ “Uptown Funk”.
He has super pussy eating powers?
I came into to cite Voodoo Chile, but Colibri already did that.
Gotta go with The Who’s I Can See for Miles - he has magic in his eyes. (and, to me, REM’s Superman is a complete clone of this Who song. Like they listened to it and said “hey, let’s write our version of that!” Not that that is a bad thing - its a great song.)
The deaf, dumb and blind kid sure plans a meat pinball.
If that ain’t a super power, what is?
Now THAT is a typo I can get behind!! I agree, being able to play “Meat Pinball” would indeed be a superpower.
I am the man with the magic hands.
(Heart)