I have not tried LSD. But I have experience with some psychoactive tryptamine psychedelics (and ketamine), mainly 4-ho-met.
The one thing I've noticed that people report, and that happened to me back in the day, is these substances at significant doses caused a sort of burst of obsession and creativity (mainly afterwards). The typical stuff. Basically obsessing over the novelty of the experience for days afterwards. I'm sure some people might get all varying sorts of feelings of being enlightened or that they've attained something afterwards.
They also seem to cause anxiety at varying levels during but I guess LSD has a better reputation in this regard.
4-ho-met and psilocin (basically the same thing) cause extreme lack of verbal skills for most people once you take enough. DMT likewise.
Dosage also makes a huge difference. When I took small doses of 4-ho-met (which today are considered on the high end according to various sites) I basically got euphoria, lack of verbal skills, and tons of hallucinations with eyes closed and when I did open my eyes e.g. the people on TV had cat or dog heads and stuff like that, but I felt rather normal in most regards albeit not very interested in engaging in normal things of life (usually just layed in bed eyes closed). This was not the case with what I considered high doses (50-100mg of the fumarate salt) but then instead total alteration of reality, transportation to different realities. Basically in comparison, the "low" doses (e.g. "ultrakill high superblaster high" doses, according to the sites today) were almost entirely euphoria (and novel hallucinations that were rather superficial and boring in the long run), relatively speaking. Where the higher doses were a lot more unpleasant and having very little to do with normal reality or my sense of anything. If I just assume that I can translate the 4-ho-met dosage guidelines to LSD I've seen on various sites, etc, then I'd say you took a very low dose of LSD but one that's intended for maximum euphoria, in my world that is. That's just my impression that dosage guidelines are catered towards the euphoria novelty seekers rather than us old-school weirdos that take it to go to the moon and lay on the floor in the fetal position while vomiting.
With that said I have found all my intakes of these kinds of substances fascinating, despite the dosage. But it got rather boring after a while with 20-35 mg 4homet fumarate salt, which I did at least 5 times, and all it did was make me feel a bit weird, rather euphoric, tons of visual hallucinations, but nothing about "reality" really changed, it was sort of just like I had downloaded an extremely visual and weird movie into my brain and was partly playing a role in the movie. Meanwhile the really high dosages were just insane and something I barely could handle (dramatic fear of loosing ones sense of self, or just primal fear in anticipation).
Anyway the situation you use it in greatly diminishes some of the weirder effects. Just moving your body erases most of the hallucinations. Some people seem to enjoy taking LSD and whatnot in a social setting in modest doses, which I assume is because it is rather euphoric, and once you move around (or have bright lights or eyes open) most of the utterly bizarre stuff is not so distracting. Everyone's also different of course, and again I haven't tried LSD. Also 4-ho-met is sometimes described as less potent than LSD or psilocybon mushrooms with regards to the weirder effects but more potent visually.
Just like my opinion that tryptamine psychedelics are rather boring and pointless (and fascinating), consider that your opinion that LSD is fascinating and so forth, is just like in my case an after-the-fact argument largely conjured by some primal program in your brain to make you do something that might on average be beneficial to your genes considering your evolutionary past. I think the biggest thing with these kinds of drugs is the novelty. Novelty to some extent seems related to intelligence, or knowledge, or knowledge seeking, and e.g. people in academia seem very much novelty driven (they seem to come up with all kinds of weird fads for society). I think certain intelligent people tend to have a kind of drive towards novelty, and they tend to inevitably confuse novelty with usefulness or truth. Some smart people like to "come up with ideas", hence novelty seekers, but most ideas are trash (even the really good ones).
Maybe you should ponder more basic things, like what "social dominance" means or "no anxiety" or "off the charts libido". Or if you even want to go in that direction. Maybe you need to reduce your libido, and increase your anxiety. That's what I mean with novelty seeking being a potential danger and mostly bunk, some people tend to get enticed by the novelty or otherwise enthralled and then the human brain is as always very good with coming up with stories to justify whatever it desires.