I remember posting this in the other thread but whatever I'll post it again.
Futurama's into remains my all-time favourite TV Intro. Such a catchy tune.
Here are a few I love as well.
Mainly for the song.
How could I NOT post this.
The South Park intro is a classic.
Can't embed the video however...
And lastly, The Walking Dead. This one always gives me the chills.