Can relate to this, when I was younger this was the same for me (and not limited to psilocybin).

However the older I get, the more useful the 'revelations' (I rather call them insights) become. As in: I can actually use them to do things better in daily life.