Thats an oversimplification to be polite. For most people it can bring the most intense and beautiful experiences their live can ever produce. Then there is (non-trivial) minority which has something broken in their core (which is a statement that can mean many things). Yes, its not for them, or only at great risk (and potentially great reward as OP wrote).
But man, I never ever came close to the simple pure beauty that I experienced repeatedly on mushrooms (for the sake of argument cca 1:1 to LSD), never with any sort of guide, just let my mind wander to places it wants to go.
And I've got married, have 2 beautiful healthy kids, was there to cut umbilical cord for both, climbed extreme peaks like Matterhorn, hiked for weeks and months in himalaya and other places around the world, all very intense.
Psychedelics changed permanently perspective on life and important matters quite a bit. Experienced very intense spiritual moments, despite being cca agnostic (and it just confirmed and enforced my views to be clear). For all the bad it can do and does, it adds so much good to mankind. Its a very powerful tool.
I am not anyhow lowering value of all other things I ever achieved in life, those are some hard won victories that didn't come without pain (and lets check in 20 years whether that stood the test of time). I gave them as a mere comparison.
Those mushrooms were that intense, it would be a lie to say otherwise. Cutting first umbilical cord was second, but then every hard peak I've climbed brought me to my knees and brought tears of joy and released emotions, those were some powerful emotions too (I guess when you struggle very hard and risk life for some specific goal and then reaching it this happens, at least to me).
But don't judge before knowing, there is nothing in this world that can prepare you for that intensity, if dose is enough (milder stuff, full stomach etc may result in different experience). Few words of description - laying in bed with eyes closed, losing gradually all the senses, dissolving what remained into mist of atoms that swirled and danced to shamanic music playing in the background. Then after a long time, very slowly starting to climb down that 'hill' by putting those atoms back together one by one, piecing together my personality, and then sense by sense, very slowly. Pure happiness afterwards, grin for an hour or two. Massive mental exhaustion from 'expanded mind', worst headache I ever had (but basic stuff like paracetamol helped a lot). Long lasting effects on life perspective.
But thats me, other folks may put the umbilical cord as #1, others those mountains or other endeavors.
