It’s not worth pointing out anecdotal instances of these occurrences since it’s so personalized and dependent on ones own experiences and state of mind.
What it offers, though — in the only way I know how to describe — is an alternative perspective. It’s like stepping outside of your usual self and evaluating things from an almost objective and completely different point of view. It’s this perspective that allows for revelations that otherwise wouldn’t happen in a sober state. This is a result of physiology and the chemical interactions in the brain due to ingestion of the substance.
It’s quite an amazing experience. Sometimes it can be scary, or odd or just funny. But in my experience, it has led to some very profound experiences and insights.