I spent some time around a ketamine abuser and it was shocking how he seemed like… at one point he was a very capable and knowledgeable person and how much was just gone.
I know a person who was doing it a lot and then stopped. It seems that at least the illusions of grandeur and the usual spiritual nonsense are not a permanent thing.