It's not coke, it's Plutonium Nyborg thank you very much. ;)
The hallucination scene with a wrecked U.S.S Enterprise flying past is one of my favorite shots. I spin the song soundtrack once in a while, and the Elmer Bernstein score is one of my faves.
If you like the movie at all, you have to see the South Park version. If the HM sequel wasn't dead in the water, I think they should be the ones to make it...