People definitely use small servings of alcohol or cannabis to alleviate the boredom of endurance exercise. I'd be reluctant to do so with opiates or anti-inflammatories because they can mask pain in a way that leads to injury.
Weed has bronchodilator properties which can help in certain cases, but I'd advise against inhaling fumes from burning before exercise.
Also, one can take a non-strenuous approach to both running and biking. People who need to be inebriated to maintain motivation aren't going to be out there doing interval training.