"Holding Out for a Hero" by Bonnie Tyler.
OK, girls and boys, more big-hair 80s: This Jim Steinman/Dean Pitchford composition was first recorded by Bonnie Tyler in 1984 for the "Footloose" soundtrack. It peaked at #34 US and #2 UK. The classic opening couplet is a modern example of the nostalgic literary ubi sunt motif. Also part of the "Shrek 2" and "Short Circuit 2" soundtracks. Masterfully covered by Joss Stone. Song? Answer: "Holding Out for a Hero" by Bonnie Tyler. "Where have all the good men gone and where are all the gods?/ Where's the street-wise Hercules to fight the rising odds?" is popularly considered a nostalgic yearning for the unreachable or for what is gone. Ubi sunt (literally "where are...") is a phrase taken from the Latin Ubi sunt qui ante nos fuerunt?, meaning "Where are those who were before us?"