Well fuck, I can't find the actual opening for "Hercules: The Legendary Journeys" so you'll have to imagine
"This is the story of a time long ago, a time of myth and legend, the ancient gods were petty and cruel and they plagued mankind with great suffering, only one man dared stand in their way: Hercules. Hercules possessed a strength the world had never known, a strength surpassed only by the power of his heart..."
I loved it and yeah, the theme is completely iconic and something it is impossible to forget. I am SURE it wouldn't hold up if I watched it now but I'm really hoping that RoseTintedSpectrum does the full treatment soon. A lot of people have been pestering him in his comments to do it.