If you aren't finding great intros in modern rock, you aren't looking too hard. 
Tool - Eulogy (2:08 minutes of wonderful buildup before a single line is sung)
Porcupine Tree - The Start of Something Beautiful
A Perfect Circle - The Noose (my vote for most haunting intro)
Muse - City of Delusion
Seether - 69 Tea
Radiohead - Sit Down / Stand Up (the whole song just keeps building on itself until the very end)
Dredg - Lechium (easily one of the most memorable in my collection)
and let's not forget-- my vote for best rock intro ever:
Coheed & Cambria - Welcome Home
Tool - Eulogy (2:08 minutes of wonderful buildup before a single line is sung)
Porcupine Tree - The Start of Something Beautiful
A Perfect Circle - The Noose (my vote for most haunting intro)
Muse - City of Delusion
Seether - 69 Tea
Radiohead - Sit Down / Stand Up (the whole song just keeps building on itself until the very end)
Dredg - Lechium (easily one of the most memorable in my collection)
and let's not forget-- my vote for best rock intro ever:
Coheed & Cambria - Welcome Home