I loved that story in the book, because it was so much like my own experience with simple dreaming. We often hear about the brilliant creativity of our dreaming minds and the deep answers that await us if we'll pay attention to our dreams. I figured that was safer than drugs, so I kept a dream journal, because it was supposed to help you remember your dreams better (it does) and unleash the genius of your unconscious.
Over time, I had several instances of making some progress on a question (programming logic design, for example) as I was on the border of awake and asleep, but these were essentially just the result of awake-enough thinking through of a problem as I lay there just before I fell asleep.
But I did have a few instances of real solutions in my sleep that I thought were major breakthroughs. The funny thing was that almost the instant I woke up, I saw fatal flaws in those "breakthroughs" that had been completely invisible to the triumphant, celebrating genius that I was in the dream. Literally seconds after regaining consciousness, I would see how ridiculous my brilliant idea was because of something I had completely overlooked in my dream state but was instantly obvious in my waking state. (Waking up literally does bring some crucial part of your reasoning back online.)
After a few of these, I put away the dream journal with a chuckle and got another good laugh when I read about Feynman's experience with LSD. After my own experience, I can easily imagine how you might feel as though your intoxicated mind was somehow operating on a "higher plane" when cut free of the restraints of reality, but it doesn't mean that what you discover there is of any real value back in the world of reality.
As much fun as it sounds, with no benefits beyond the entertainment value and the serious risks involved--a top student and mentor of mine back in school raised his consciousness so high that he lost the ability to feed or dress himself in the real world ever again--I'll just stick to actual consciousness.