The Simpsons has some intros that push up to and sometimes over two minutes in length. Sure, they're often clever and do take time and money to create, but it's still time taken from the actual show.
Supernatural or Lost are good examples of how an intro should be. Literally just the name of the show on the screen for a few seconds, no theme music that gets annoying halfway through the season, no montage of the characters tromping around a fountain, just skip to the show.