...is pretty good:

The Pink Floyd ~ Shine On You Crazy Diamond, maybe that doesn't count as it's in parts

short:
The Clash ~ Know Your Rights, hits the ground running

EVERY song on The Cure's Disintegration.

...in the (brilliant) short intro category. Here's the most brilliant long intro I can think of (long in terms of proportion to the length of the whole song). The vocal comes in at 1:28, the song lasts 3:10 - nearly HALF the track is the intro, but that does it a disservice really: the intro IS the track, in a way. Genius. And a modest hit too.

but it's that good, it's worth posting

A Hard Day's Night yet!

The Stone Roses had a lot of very long intros - the best example being the first track on Second Coming - Breaking Into Heaven, which is 11 mins long and the intro about half of that.....

It's hard to tell when the song actually does come in. But when it does it lasts for over 9 and a half minutes so you start to wonder if it will ever end.

...I think, to songs that basically have NO intro. Like this one:

My favourite 'long' intros are mostly by the same artist, Sieben (real name: Matt Howden). He uses just his voice, violin and layer upon layer of loops (some of the percussion sounds even come from tapping the side of the violin or rubbing his stubble across the bridge). On some of his albums - including one of my favouties, 'Ogham Inside The Night', he leaves in most of the layering process at the start so that you can hear how the song builds up. Sorry for long-winded explanation but I think he's a genius, hopefully the title-track of that record will illustrate what I mean:

Born under Punches is little more than a drum fill and a shout:

Planet Claire on the other hand...

or just part two of the songs:

Layla

I Am The Resurrection

when we used to say "Oh and it was the long version of Layla" as opposed to now when I'm totally fed up with that piano/slide dripfest that follows. Layla is a great track, the 7" single version that is.

Is 'The Operation' by Morrissey, from Southpaw Grammar, about 2 and a half mins of drumming. The album is also notable for his two longest tracks, both with long intros ('The Teachers Are Afraid Of The Pupils' and 'Southpaw').