Calypso by Suzanne Vega springs to mind.

"When You Sleep" by Cake

lyrics www.tsrocks.com/c/cake_tex..._sleep.html

"Flight of Icarus" - Iron Maiden
"Tales of Brave Ulysses" - Cream
"The End" - The Doors

www.serpentinemusic.com
psychevanhetfolk.homestead.com/WI...tml
www.theskysgoneout.com/ --great podcast!
www.noside.com ---Contemporary Nordic roots music now available to North American audiences. Ancient musical traditions in contemporary folk, rock, jazz and world music ...(i love this label)
www.paganradio.net/

Really the list is endless,,,and there is music out there that appeals to lovers of myth or full on pagan re-constructionists!
That said ,Venus is my fave pop song with "myth" pagan Goddess references! I think it was originaly performed by Shocking Blue? But Bannanarama, Posh Spice and a million others have covered it in one era or another;

A Goddess on a mountain top
Was burning like a silver flame
The summit of Beauty in love
And Venus was her name

REFRAIN:
She's got it yeah, Baby, she's got it
Well, I'm your Venus, I'm your fire
At your desire

Her weapon were her crystal eyes
Making every man mad
Black as the dark night she was
Got what no-one else had
Wa!

Led Zeppelin was brilliant at fusing mythology with pure r&r. I'm thinking of the Immigrant Song particularly. You know, Valhalla and all that.

"They Might Be Giants- birdhouse in your soul (mentions jason and the argonauts)"

They Might Be Giants are big fans of the excellent British band XTC (one of my favorite bands od all time!), and in fact have done two separate tribute albums to Andy Partridge and the boys.
now XTC are a decidedly Pagan band, with such songs as 'Dear God', 'Greenman', 'Easter Theater', and 'The Wheel and the Maypole'.
but they also had a song on their 1982 album English Settlement called 'Jason and the Argonauts', which may be the reference point for TMBG.