Sorry guys, this is more than five, but I couldn't narrow it down...
For any kind of Workout, these will make you want to go out and kick some ass:
MoFo (especially a live version - Leeds Popmart is a good one)
Elevation (Tomb Raider Mix)
Vertigo
Discotheque (New Mix)
Bullet the Blue Sky (any live version)
Love or Peace or Else
Hold Me, Thrill Me, Kiss Me, Kill Me
Mysterious Ways
Lady with the Spinning Head
I Will Follow
And, some good ones for a long, steady state workout. Just put your head down and keep on going...
Desire (studio)
Seconds
One Tree Hill
NUMB (test this one out if you haven't, it does the job suprisingly well)
I'd say Sunday Bloody Sunday, but the "How Loooonnnngg" part can be a death sentence during anything cardio...