Streets U2 is an awesome intro. This guy starts from scratch if you click a little way back on how to build it up.
https://www.youtube.com/watch?v=h4_-cN15ToI
From the same album. I would argue that "Exit" is also an intro that beguiles, because its outro is so short.
The great director Peter Weir made a quite thrilling use of this song's intro in the interesting, strange moody psychological drama "Fearless", starring Jeff Bridges...enjoy the ride!

:
https://www.youtube.com/watch?v=RUBaRqY_NqAI must admit that this song and especially its intro always gives me chills, almost 30 years after the album's release (another one of my fav song on this album is "Red Hill Mining town")
Well, if it's gonna be old school rock and shit... bit of AC/DC, anyone? You know what track this is...
https://www.youtube.com/watch?v=V5iTQf5PDyY

and what about "Hell's bells"??

Some others "heavy metal" intros i like...:
On my favourite Thin Lizzy album "Renegade"...
The title track...i love this bass line, the clear guitar sound, Phil Lynott's warm, moving voice and lyrics:
https://www.youtube.com/watch?v=z1K539_fdUgSame case for "It's getting dangerous":
https://www.youtube.com/watch?v=Uadp-BL_QH4"Angel of death":
https://www.youtube.com/watch?v=RGtJ8WR5ShcJane's addiction "Three days"...Perry Farell is genius:
https://www.youtube.com/watch?v=SmvG2GZ3S7oSuicidal Tendencies "Asleep at the wheel":
https://www.youtube.com/watch?v=juaM1Zrq9iEIron Maiden "Killers"...again, i love the bass line:
https://www.youtube.com/watch?v=rwY3Ftfdy6M