In some instances, it can be that someone gets high and imagines an epiphany. If then, they put that thought into something solid, that's more akin to them mis-using the tool. Overall, it does not mean that the drug is at fault. A misunderstanding is likely, if not always, the fault of the person doing it.
Drug epiphanies if they were purely from the substance rather than tethered to anything meaningful tend to go away when the substance itself does too, if they aren't a drug journalist anyway and/or don't tend to hold onto experiences when altered.
It doesn't help that the mind can have an easier time calling upon memories connected to the substance, such as the high schooler who smoked tons of weed during lunch time before his Math class finding it suddenly harder to do math when he went sober, or the guy who suddenly remembers past chapters of his life when he gets back to the drink, as such phase learning principles are what can give the impression of blacking out, purely through difficulties with recall, when it may very well not be happening.