The HBO comedy series Silicon Valley does give that impression. Yes it’s a satirical comedy but good satire has to have an element of truth in it to be good!
I've been involved in a number of start-ups. No major dope use among the engineering staff. Some pot smoking by a few, sure, but nothing heavy. No coke. I can't speak for management, I try to avoid them as much as possible.
I wouldn't trust anything put out by HBO - even in humor - as an indicator as to any level of reality. Day-in-day-out Silicon Valley is a very unglamorous, high-stress place.