Athletes drug use tends to be restricted to AAS (steroids) and amphetamines (or weaker stimulants: modifanil, ephedrine, or caffeine).
Nicotine is widely used in baseball, tennis, golf, and football (to a lesser extent)
There are a number of drugs an athlete may use that are not recreational. The best known most widely used being clenbuterol ( an adrenergic receptor agonist).
In the older days, MLB players used just about everything under the sun. Now baseball players and athletes in general tend to only use drugs that they perceive to enhance their athletic performance.