The trouble is that the sort of drug-induced insight (or pseudo-insight as some would call it) you refer to is usually accompanied by strong euphoric effects, which impairs your ability to dryly reason about those experiences even a long time after the fact. Nor can I completely shake the impression that those who believe a e.g. a DMT trip offers genuine insight into the nature of consciousness simply had an insufficient grasp of the subject beforehand.