If you think Kekule's story is wild, you should read about how Kary Mullis came up with the idea for the polymerase chain reaction!
But I think if you are in the throes of a problem, pondering it constantly, day and night—it is in these times that an insight will make its way to your consciousness (drugs or otherwise).