The Rocky Horror Picture Show has a bunch of great rock numbers e.g. Science Fiction/Double Feature, The Time Warp, Sweet Transvestite, I’m Going Home… It is originally a theater play, though.