Not erotic, no!! But I do get lots of very vivid dreams. To the point that I now take the patch off at night and have an inhaler ready for when I wake up in the morning so that I can get an early fix of nicotine
When I used the patch I would get a mixture of nightmares and erotic dreams. Sometimes the dreams would wake me up in the middle of the night, sweating, heart pounding, almost feeling like I ran a marathon. I hear you on the boost to the self-esteem with the erotic dreams though...hehehe!!
I am getting ready to quit again...hopefully this time it sticks for good. I have a supply of patches waiting to be stuck on the arm. Hopefully the dreams don't get too out of control this time.