I'm definitely curious about psychedelics with sex, I hope to eventually try that. Although it's not something you can do often. My idea with the post is if people have a substance they often use in a sexual context.
I feel like from the psychedelics, 2C-B probably has the highest potential to be very erotic. From my experience it doesn't push you deep in your mind the same way mushrooms and LSD do and as a bonus it's quite stimulating. The sensitivity enhancement is also quite impressive. It has a reputation for being erotic. I've never tried it with sex or masturbation, but I can definitely see the potential from my experience. People calling it a weird mixture of LSD and MDMA, I think are right, at least it felt that way to me as well. Although again, it probably depends on the person and it definitely depends on set and setting.
LSD and mushrooms I also haven't tried for sex or masturbation. By intuition I feel like in lower dosages they can probably work. It's not impossible in higher dosages, but I feel like you won't be able to focus as you're exploring your mind and your environment and also your perspective on sex might feel quite alien, not to mention the body load probably feeling distracting. I might be totally wrong though so take it with a grain of salt, that's just my personal thinking about them right now.
I'm assuming the trip didn't involve a high dose, because my comedowns on higher doses were always weird.
Well Cannabis is definitely very different for everybody. Not only that but a single person can have different "phases" with it. I've had periods where I'm sure it wouldn't have worked for me as well. At some point I just felt it doing it for me, that's when I started using it more for sex.