Coffee, alcohol, nicotine, and pot are all just normalized. Nobody cares. We chat about it in passing (e.g "so Friday I was high....blah blah rest of story"). Coffee is perf-enhancing but people treat it recreationally.
The performance stuff is alluded to but not really in any detail. Cocaine, adderall, ritalin, modafinil are all considered "ok", to some extent. As in, "ok. You do you, I guess" and it's fine as long as productivity isn't impacted. Cocaine is definitely the black sheep of that bunch, but it's still a fairly clean sheep.
Psychedelics/dissociatives are never admitted to, at least where I work. I have used them (LSD, DXM) but I wouldn't ever consider doing them at work or on a weeknight. They have little business in programming, I think.
Then, finally, the "white-trash" drugs. I don't know anyone who uses opiates, meth, crack, PCP, ketamine, kolonopin, etc. RXs are probably being abused more than I'm aware, but generally, our drug use is pretty elitist. If a poor person would do these drugs, not-poor people stringently avoid it.