SOedipus listed a few. Probably chuck TNG up there as well as it's now ingrained in the brain forever through repetition.
Enterprise, although it does kind of suck a lot, has a pretty dope intro.
Aside from being fav ending to a TV the intros to the Siege Of Mandalore arc (final 4 episodes of Clone Wars) are amazing. The whole tone of the show changes as it gets closer to, then takes place during the final of ROTS. All becomes more cinematic and increasingly grim.
Kevin Kiner does his own version of the John Williams score during the ending montage.