I think it depends on how you react in particular, people react to drugs in different ways. I know that more often than not, substances make you more dull, (especially alcohol), so you are more uninhibited but don't feel as clearly, so it is harder to orgasm.
If you are able to orgasm on your own, have you tried to masturbate during sex? It might help as a first step to help bring orgasm into sex. You can just reach around and stimulate yourself while he's in there
If that works, than ask him to do the same, stimulate you during sex. Most women do not orgasm from sex alone, we need some extra stimulation.