My sex drive doesn't go away. I tend to get as horney as I normally fo on opiates (I'm clean from drugs now though).
Its just very hard for me to get an erection. Wether it be from foreplay, dry humping, a hand job. I very rarely jerk it, but I never will well high on opiates again.
Fair warning to all: it will take one-three hours. Your arm will be tired, and the skin on your dick will become raw making sex even not high unenjoyable for almost a week.
When on opiates getting horeny/wanting sex is as natural. Its just very hard to obtain erection. If I'm lucky enough to get one, one of two things happens. I will loose it very easily, even from stopping kissing my girl for a few seconds, or changing position. If I loose it, good fucking luck getting it back. Other times it just takes forever to cum. I know longer sex, more fun. Think again. Near the end both of you just want it to be OVER! You don't want to stop either due to possible balls of a blue color, lol.
Lastly I am drug free now, but here's my expereince on things I've been high/un-sober on while having sex.
Opiates:explained above
Weed:great sex, amazing
Alcohal:best sex ever
Weed and alcohal:mind blowing
Gabapentin:very good, cum to fast
Musslce relaxer/benzo:same effect as opiates just worse.

:/
Anyways, keep fucking \m/