Climbing in non-winter conditions (or indoor) and ski touring are by far the best things for me. I come happy like a toddler after a session / trip on skis. I just don't get this from typical old school team sports, or even single/duo ones.
The biggest thing isn't the physical effort part, not for me. Its exposition to your fear of death, fear of injury which are very strong emotions. You have to repeatedly overcome your biggest fear in whole life and push through, maybe 10x maybe 50x per evening. Do it for 1 or 2 decades at least 1x a week and your personality will change for the better. Also helps with various milder mental issues, not fixing them but improving (this can be said about every sport but its way more intense here).
There are other sports where you expose yourself to similar fears, but in climbing its very easy in afterwork session, without the actual risk (valid for sport climbing).
I've gone dozens of times, mostly because friends can't get enough of it, but I find it slow, boring and expensive. I've done mostly outdoor, but some indoor, and while sometimes I enjoy the technical aspect of it. Solo back country trekking and camping seems "scarier" to me.
Personally, after work, the last thing I want is intense stimulation, or to be around a bunch of people pulling on plastic. I'd prefer a nice ride or to get outside, away from everything.
It depends how (de)sensitised your flinch/fear/other responses are to various things. I practice martial arts (swords, wrestling) and even when I know I can parry a hit, or that it'll be pulled before doing me any real damage if I don't (or the weapon is a light synthetic that I'll barely feel through the PPE), I sometimes find the natural “pointy thing heading towards my cranium” oh-shit reaction cannot be resisted. Same for a throw that I know I will land safely from. There are those who have less efficient self-preservation reactions, or more control to resist them as needed, or both, and there are those who are far more reactive, sometimes significantly overly so, than I.
I assume⁰ climbing is the same: some don't get the natural fear response because their rational thinking combined with all the PPE damps it down, some very much do despite all that.
--
[0] assuming as I've not done any myself so don't have a first-hand point of reference
Also, yeah, it's definitely not for everyone. I only tried it out at 39 and am finding it super fun and satisfying/rewarding, so I'm all-in, but a lot of people "nope out" due to total disinterest after trying it!
Indoor routes are generally very safe due to frequent bolts, outdoor it depends, with bolts easily 4-5m apart, not so much. I still talk purely about sport climbing with drilled bolts, not trad climbing where you put expansion devices into cracks yourself or wedge tiny metal bits and pray intensely you won't actually fall on them.
I don't want to go into detailed climbing & fall physics but if in such a route you fall just before next bolt (or during an attempt to clip into it), you can easily swing up to 8m down, hit a ledge, part of rock with serious force, or just be smashed against rock face hard (if you are in overhang then all is fine obviously, just belayer will fly hard). Broken/twisted ankles, wrists etc are not that uncommon in such situation, or worse depending on position, usage of helmet etc.
I love the sport and the physical challenge but I don't buy into the whole weed-smoking "I'm so counter-culture, bro" self-image. It's like Crossfit but for hipsters with shitty tattoos.
More than once, it seems, I (as a noobie) have been in the way of some "bro", who took a date to the bouldering gym in order to show off in front of the woman and (pretending to assist) to feel her up.
Maybe it's different where you train. Is it?