There was a story on HN with people trying to microdose on LSD, and the alleged benefits - long story short, when they asked peers about their performance, they noticed they're more distracted and not more productive, while those doing the microdosing thought they're on a super productive trip.
We notice this manager is in a constant state of "brain fog" to a point where his speech changed (like he's drunk), while I'm pretty sure he thinks he's a 10x machine and wouldn't be able to pull all of his workload off without drugs.
You get more sick days, you need more time to recharge, while thinking you're on your absolute productivity peak. And when you crash, you're basically unemployable / unproductive for 6 months to 1 year.
Not worth it IMHO.