Now my tolerance to weed is so low I only have to have a couple of tokes more than the sweet spot and I can't get hard properly til after the peak, but I used to have sex when I'd smoke around 1.5-2g a day, and it was amazingly sensual sex, the orgasms were great but not as amazing as when I'm sober, with a few exceptions when I have got the sweet spot with the right kind of weed buzz.
Moroccan sativa kief smoked in a bong used to give me & my ex the most energetic lengthy steamy sessions in the sack - literally fucking all over the house, room to room without me orgasming - she'd have like 4, 5, 6 - a few at least until I'd cum, and we'd collapse on the floor - proper loving sessions.
Sometimes though I can be too overwhelmed by a fat high grade joint and my body just wants to be high and not fuck. THis was a long time ago this last happened though - I'm not sure how it would be now.
I like having like 2 drinks after a bit of a blazing sesh with a lady, then we canclose our eyes and just touch each other in the darkness, and reach the right arousal state where we're aching to fuck each other, and then we do, and then it just goes on til we cum together. Mmm I'm beginning to miss a few ladies from my past.