The Michael Schenker talk in the UFO thread reminded me of The Legend of Black Heaven. Schenker is the main character's guitar hero, and honestly the whole series plays like a tribute to UFO. Space ships, alien hot chicks, groupies, mid-life crisis, flying Vs and rock and roll as the ultimate weapon. And the absolute best theme song of all time, used with permission/blessings from John Sykes, who also provides some other playing in the series.
[video]http://www.youtube.com/watch?v=Eu1pvYWNp3o[/video]

I've watched the series three times and haven't skipped the opening theme on a single episode. So much awesome.
Any other TV show themes that could compare?