I have a pretty messed up knee that gives me nightly pain. I find that Advil or Aspirin sometimes doesn't work so instead I smoke a little weed, the pain disappears and I can fall asleep (after the initial high wears off). As for productivity when I'm high, I would say that it can assist in working through an idea when stuck architecting something, but I always make sure to check my work the next day; naming variables or services after foods and characters on the TV show I might have in the background makes for a very confusing code base.