I looked through my iTunes library to come up with a few ideas in addition to the "obvious" ones like Flashdance, Footloose, Dirty Dancing, Grease, which all have great ones for workouts, and found a few interesting ideas.
The Blues Brothers soundtrack has some catchy songs
So does Blues Brothers 2000 (really cheesy, bad sequel, but great soundtrack)
The Fully Monty (land of a 1000 dances, You Sexy Thing, Moving On Up)
Reservoir Dogs (Little Green Bag, Hooked on a Feeling)
The Soprano's theme song - Woke Up This Morning (great beat!)
Goonies - the goonies song by Cyndi Lauper
Austin Powers - Beautiful Stranger