Holding Out for a Hero

Where have all the good men gone and where are all the gods?

Where's the streetwise Hercules to fight the rising odds?

Isn't there the right knight upon a fiery steed?

Late at night I toss and I turn, and I dream of what I need

I need a hero