I'm biased because Rush is my favorite band. As much as I love those, let me give you a few others that were pretty amazing.
Judas Priest, during the Us Festival back in 1983, had a pretty cool intro which I can't find on video anywhere. Rob Halford rode a chopper up onto the stage before starting the set. This is what followed: