Some good ones in here!
Here are a couple:
For longest coolest intro before the words kick in, its gotta be 'i need a lover' by johnny cougar melonhead.
for historic significance, and cool, "i feel fine" by the Beatles - first song to ever use guitar feedback, plus the song starts as just feedback for the first few seconds.