My vote goes to Buffy the Vampire Slayer. du DU DU DU! dududududuBUFFY TIME!
Angels theme tune is awesome too.
I also love the league of gentlemen title music. they changed it a bit in the 3rd series and it was even cooler.
Lamest title music? I'd vote for Neighbours off the top of my head.
So yeah, DiScuss...