i only recall those dreams in that one where you're a guy in a derelict ship with M and S, that one where the *seed* fuels the ship or some dumb shiet, it had a bowsette dream lol
For me its just a way to lazy writers put sex without develop a story to reach it, like game start dream sex scene right way, but 'real' sex is only in chapter 20
Since most of the time I just skip dialogue and story to see the good bits. Dreams can be good bits. I will watch it... Who care if it feels fake or 'off', if it has nice art, I will bust it out!!!
Most folks don't skip the dream sequences in my games. In fact a good amount of players play my game just for them. I'm probably the exception to the rules though.
If it is something like remembering an important part of your past that has something to do with story, that is ok.
But dream sex scenes, I really dislike, like the MC has a sex fantasy about his sister or whatever... had pass does nothing to advance any relationships or story.