Shock Treatment. This may not be anywhere near as great as Rocky Horror Picture Show but it's fun and twisted. I listen to this soundtrack maybe as often as RHPS.
Wayne's World 2. I can see how it gets hate for being too wacky and relying more on bit-jokes (Jurassic Park, fight sequence). But man does it have some really brilliant moments (traveling to London montage, "Can I still be Garth?").