Sure. LSD is very special because it actually helps to focus more as well as increases creativity (if we're talking about microdosing). Stimulants and opioids are not really that common. High quality cocaine can be seen but it's not really "normal" like the other drugs are. Meth, crack and heroin are hugely frowned upon, it's a failure to be a user of these. MDMA and LSD have very different effect based on dosage. It's entirely possible to work (better than normally) on small doses and of course it's purely recreational in bigger doses.
And the drugs that are frowned upon... that's (as far as your experience goes) in the tech industry? I know lawyers that had meth addictions. Peter used coke, adderall and meth. It sounds like cocaine is more widely accepted (and perhaps legal stimulants like adderall, ritalin, concerta, etc.?)
Yes, in the tech industry, and all of it is of course only my personal experience. It's seen as a failure to get addicted, so these highly addictive substances are out completely. They also don't really give you anything apart from problems (compared to other drugs). Cocaine is seen as somewhat OK but uncommon because it's hard to find cocaine that is of OK quality for an OK price (you definitely can't buy that on the street) - and again, addiction is a failure. Some people fear legal stimulants more than they fear LSD; but they're definitely pretty common (especially within student groups) and not frowned upon at all, I've seen people have (not prescribed) Adderall placed visibly on their desks.
Being visibly influenced by a drug is a huge failure as well. It's OK if you take and it's not visible but once you act differently (e.g. talking too fast, slightly jumping around while standing etc.), people will think badly of you and you will be a target of jokes. Having a different behaviour even if you haven't taken the drug (e.g. if you get cravings for it) is seen as bad too.