Anecdotally...
1) Friend from college working in machine learning space who just moved back to SV from Asia, saying that the tech culture in Asia suffered from a lack of creativity. In the same conversation I brought up having used psilocybin and he freaked out, thinking it was going to damage my brain.
2) Another friend from college who's a hardware engineer. who found it strange that I didn't want to drink whiskey with him but regularly use psilocybin. He also warned me about brain damage.
3) Friend from work whom I knew socially. After he quit working, I chatted with him and suggested that if he wanted to try psychedelics now would be a good time, before he decides whether to go back to working. He seemed to be surprised, and just made a comment about Steve Jobs to cover up the awkwardness.
4) Another coworker I worked closely with and had a good opinion of me because of the work that I had done, who had gone to another company. I asked him if he knew anything about microdosing while having lunch and he said not to try that stuff because it would mess up my head.
5) The Burning Man guy was someone I'd worked with before. He told me about his recent BM psychedelic experience after I told him about having used ayahuasca recently.
Point is, my experience of sampling people I know in SV both socially and professionally hasn't yielded anything close to "yeah I have used psychedelics to help my work" even when I didn't ask them straight up if they had used it, and instead volunteered my own experience first.
I worked in large companies in South Bay, not SF-based startups. That probably had something to do with it. Still, all the press about SV and psychedelics gets tiring when it seems not to take into account the likely uneven distribution between South Bay vs SF and large companies vs startups.