As with alcohol, I think it really depends on the individual.
For me, I find that too much regular pot puts me in a dim, slightly dissociated place. But it might also be that in the past I may have smoked too much cannabis at times when I was already headed for dim dissociation, so bit of a chicken and egg situation maybe. Meanwhile I have friends who swear that cannabis has saved their life, helping them cope with anxiety, OCD, etc.
Either way, if I had to choose between a pot or alcohol abuse problem, I’d def choose the former. It’s not ideal, but it’s far less likely to kill you or ruin your life.
I am a very “techy person” (in fact Y-Combinator’s Hacker News has been a partial Reddit replacement for me), but like you, I too cringe at Lemmy’s constant stream of shitty star trek memes, repetitive “this is what living with ADHD is like”, and posts with days-old news items from 3rd rate wannabe-journalism sites. I mean a quarter of this site is literally screenshots of Twitter posts.
The obvious answer to the shitty content here would be to stop complaining and just start posting the things I’d want to see. But there’s a sense of futility in throwing good things into what feels like a giant pool of detritus.
Anyway one of the great things about old reddit was that, overall, the site (or rather the reddit hive brain) did a decent job at pushing the good stuff to the top. For reasons I don’t entirely understand, that doesn’t seem to be happening as much here on Lemmy.