I am old so this list might not get many cheers.
Star Spangled Banner/Purple Haze - Jimi Hendrix
Long Cool Woman in A Black Dress - The Hollies
Eruption/You Really Got Me - Van Halen
Legs - ZZ Top,There are two versions of it.
You Shook Me all Night Long - AC/DC
Walk this Way - Aerosmith
Mony Mony (Live) - Billy Idol
Born In The USA/Born To Run/Dancing In The Dark - Bruce Springsteen
The Midnight Special - CCR
And probably my all time favorite intro
[youtube=425,350]http://www.youtube.com/watch?v=C-3cIoWgdMg[/youtube]