I had a dream once in which an ex-girlfriend from years ago who I was still in love with appeared and told me that I would never have her back so I should stop being so obsessed with her. Good advice, perhaps, but not what I feel I deserve in my own dreams...
Now that I think about it, I realize that I can't remember ever having sex in a dream. So much for dreams as wish fulfillment.