the long lasting effects were negligible for me. the biggest change was that i realized i might be "on the spectrum" but it isn't as though it was a life-changing realization.
i agree regarding your final point. i do think that psychedelics are more "helpful" for people who are extremely extraverted or otherwise reluctant to reflect on themselves.