Well the ego or the self as a psychological structure is what makes one able to connect to reality and understand things, putting them into the right boxes and contexts; it might be malformed in a lot of places - and it is for all people - but its also the tool by which one can cause or attempt informed change in oneself and the world around one. Any attempt to disintegrate the ego per definition leads to schizophrenic (split or splintered mind) illness and that is also one of the possible dangers in both schizoid and narcissistic disorders, that a stability that is present in the disorder can be interrupted and give way to psychosis proper - a state which will be utterly useless in activating any positive change and not easier to treat than a personality disorder.
On the topic of drug induced "insights" I find it a bit funny that some people tend to think they will have insights while under the influence of hallucinogenic substances. After all the hallucinations, if at all, will give rise to encrypted, symbolized complexes not different from the dream world and will be much harder to understand than the everyday experience - the latter of which those people usually are already incapable of deciphering. So in other words you would again need someone to assist you with deciphering, which paradoxically would lead you f.e. again into a psychoanalysts office.
On an emotional level I can understand to a degree though the wish to meet some wise, maybe transcendent entity who will finally impart on oneself the knowledge one has never gotten or maybe give one the love one has never gotten or whatnot. But expecting this from a lifeless substance I find somewhere between naive and delusional.