It makes the standard 9 to 5, hour long commute, and retire at 65 shtick unpalatable, but we in the West live in a radical society where you can already smoke pot, drive fast cars, play loud music, not start a family, and so on. Part of that is attributable to us living in a post-psychedelic world.

Your mileage will almost certainly vary. It changes people in interesting and unpredictable ways. Sometimes for the better sometimes for the worse. I know people who became much more grounded through their use of psychedelics. Others much less so.

Some changes are predictable. For instance most people will stop abusing drugs after strong psilocybin trips. See the work of Rolland Griffiths.

Most but not all. The opposite trend is less common but totally possible from personal observations. saying that a psychiatric procedure will result in specific changes would be stretching the truth from probably to necessarily. The first result I found in Google related to Griffiths is here: https://pubmed.ncbi.nlm.nih.gov/31084460/ They are doing an anonymous online self selected reports and they find a strong effect but also 17% do not appear to exhibit the trend.

For some perspective, this is the current state of the art pharmacological treatment for substance abuse disorder, as in no other available treatment has a stronger effect.