As someone on the aphantasia spectrum, I have a weak relationship with dreams as is, but it does happen, and they do feature that, yes. If I am dreaming of something like that, it’s typically for some kind of in-universe agenda, or if I’m dreaming of events resembling the second thing I mentioned above, there’s a snowball’s chance it’s not a nightmare, but none of that has happened recently to my memory, as my piece of dreamland is preoccupied by things I miss.

Ironically, as an asexual who happens to have turn-ons (the term “asexuality” refers to attraction to humans, it can exist as a label even if attracted to non-life), I have actually tried often to build up my feeling of attraction by not indulging myself in the daytime, which in turn I hope would pressure my dream adventures into not being nostalgic. For brief periods, often it works, albeit you might say it’s way more ritualized for me in my dreams.

I am likely asexual as well and I only had a sex related dream maybe once in my lifetime. Never had sex either, although I’m not necessarily totally opposed to eventually trying it.