When I was into drugs here is what they did to me in regard to the topic.
Marijuana/Hashish: Made me super horny.
LSD: Made me super horny and even in my life-like acid sex fantasies I would trip on the visuals.
Psilocybin mushrooms/shrooms: Full of love from the cosmos to my family, friends, and even my friend's GF at the time, but it was all platonic and I felt asexual.
Amphetamines Dexedrine/Blues/Adderall: I would get super aroused and would do long edging sessions alone, or I would feel insatiable but not able to get hard.
Powder Cocaine: I got super aroused and horny over things that were not sexual, but the crash/comedown was horrible, I did not like how it was expensive, and did not last as long as low doses of Dexedrine did, it felt like a more 'clean' version of Methylphenidate. The hedonistic and insatiable desire to keep using it made me only use it once. I am thankful for the Colombian mule who carried it to my country in condoms in their lower digestive tract.
Methylphenidate: I got horny. It was like a 'less clean' version of cocaine that lasted much longer and the crash/comedown was no big deal and I had no real desire to become hedonistic, use it daily, or compulsively redose until it was all gone.
Nitrous-oxide: Made me feel sexy, full of laughter, and numb in large doses of medical grade nitrous. In lower doses of food grade nitrous it just made me laugh a lot.
Alcohol: Made me feel super amorous, sexy, horny, sexually agressive, and made sex or masturbation feel like 'work' in that it was extremely difficult to finish. I only had sex drunk maybe 6-8 times. Even when I was extremely drunk on amounts that others would have had to go to a hospital for, blacked out from, or spent all night vomiting up I was careful and had safe sex. It caused me to kiss so many men and women in bars, dance clubs, at parties, etc. that I am unable to calculate how many it is 1,000 or close to it. I was not attracted to all of these people and sometimes they approached me. Oddly enough I have never had any type of herpes like cold sores or other types, or had mono. I guess maybe the constant drinking of large quantities of alcohol killed any viruses? I don't drink or use anything now and have not for over a decade.
Kava kava: made me relaxed and horny.
I never used DXM, special K, METH, ANGEL DUST/PCP, heroin, MDA, MDMA, research chems including 2cB, crack, Amyl/Butyl/poppers-they are very expensive for a tiny bottle and for the price of one bottle I could have bought various different drugs, or Salvia-I considered it but then saw a friend who was extremely experienced with both LSD and mushrooms have a bad trip.