It's not quite the same as a traditional hallucinogen but there are some vivid dreams. In fact, that's where the term "pipe dream" comes from, from the dreams that opium smokers would have while high. I have taken a lot of heroin in my life and although I never experienced something to the extent that Sacks is describing I did have some strange and very vivid daydreams while high.