It's kind of like sex in that sense. Most people would be wrong if they judged how sex would be for them based on their first few times of trying it. The first time I tried weed, I didn't feel anything really. The second time, I was tripping balls and it was horrible. I managed to scare myself into thinking that the weed was laced with some heavy drug. I was alternating between crying out of fear and then laughing when I'd realize how ridiculous I was being and then crying again. Weed has never had that strong of an effect on me since then.
The aphrodisiac effect only started happening over the last year, especially since I started having sex regularly (with Dryvus). The impulse to clean and reorganize my life too. Weed, like many drugs, can kind of play off or accentuate your normal state. If I'm anxious about my life, which I have been this past year, weed makes me want to take immediate action to make things better or to make myself feel better about my life (like by cleaning a dirty room). Since I'm now very frequently horny when I'm sober, weed has been making me outrageously horny.
It has a weird way of giving you more perspective. I see things in a clearer light. I suddenly notice how messy I've let my room get, so I get the urge to clean. I suddenly remember all of the tasks I've been procrastinating on, like arranging an appointment or something. Little things, like something that Dryvus had said to me earlier in the day when I was sober, suddenly hit me as being so sexy. Fantasizing about sex or watching a romance movie is so much more potent when I'm high. And it's easier to appreciate the things that I might usually take for granted like the vastness of the universe or the course of human history. Weed basically just makes me think a lot and more excitedly, which is at the root of all of these effects.