Speaking from personal experience, my use of psychedelics has profoundly realigned my goals.
One of my earliest goals was to become a clinical psychologist. I like people and I like how they tick, but my first use of LSD caused a reevaluation on that.
I hate giving advice that gets ignored, and I was entering a profession where this is the majority of what happens. You have to be nice and calm and keep repeating steps until people finally get the picture and listen to you.
Not only was that not for me, but I didn't even want to stay where I lived. It not only made me reevaluate my goals but my perception of risk.
I wanted to travel and visit friends I had made online, so I did. I was 18 and did it alone, friends said I was insane for taking such a "risk". I'm now living in a different country (continent too) and married to one of those friends I visited.
Recently I took a strong dose of magic mushrooms and it had an unusual response. Normally I experience what I call uber-Ego. It's a solipstic euphoria where I feel like I'm God and my subconscious created everything to entertain me. However, this time it felt like something dealt a death blow to my soul.
This last time, I realized I hated my life. I live in an urban area, which I hate. I'm a country boy, I always wanted to live in the country. Now with a 18 month old, I'm dealing with hating the life he has and is going to have.
Me and my wife are never home because cost of living is so high. I see my son between 5pm and 7pm on weeknights, so does my wife. He spends almost 5/6ths of his waking time with other people.
We're now planning on selling up and moving to the country where her family lives. Within a couple years we can quarter our living expenses, which would put our costs low enough that I could be a career writer - something I gave up because I had to pay exorbitant expenses to hate my life.
This last time made me depressed, and I still feel it. I've been working almost every night from when my kid goes to bed until I do on writing.
I don't think the mushrooms made me depressed, not one bit. I think the mushrooms made me bypass my superego that was blocking me from seeing my wants whilst catering to my needs.
I definitely changed personality wise afterward, but I know I had been annoyed and angry for months for reasons I couldn't explain, and in hindsight I'd been annoyed ever since we put our son into daycare.