Holding Out For
Hiro, by the great Luke Ski, featuring Carrie Dahlby
No video available at Youtube, but the song is available at Amazon, Bandcamp, etc. I believe it refers to the character Hiro from the television show Heroes. It's a novelty song, but valid, I believe.
https://lukeski.bandcamp.com/track/holding-out-for-hiro
EDIT: Son of a gun! Found it!