When Ulrod returns to the city I would say that it is very likely Cyanna would start putting out for him. In her mind she's badly damaged her friendship with Leto and potentially even Rose if Leto says anything to her about Cyanna drunkenly coming onto him. So her self esteem is going to be in the absolute toilet for a while and as a result she'll probably put out semi-willingly, which is to say she'll pull the whole "We shouldn't be doing this... we shouldn't be doing this... we... shove that dick in harder." stuff with a little moping afterwards. Remember that after one extremely pushy segment where she gave Ulrod head she was instantly okay with sucking his dick whenever he wanted it. There's literally a free roam scene where she's sucking him off in her shower.
As for Rose, well, the Duke now has proof just how effective sex is to charging the magic laser piss crystal towers. Rose will be cranky about it but she should be going for horse back rides since going for one is what saved Leto. The mom and sister in HC2 had less reason to fuck their partners after doing it for the first time and that didn't stop free roam events from popping up pretty quickly after their first times having sex in the game. Also the characters in HC3 are indicated to have kept fucking for as long as they could in that scene, which should help immensely in the "I can't help it, it felt so good." department. They'll have their personal excuses ready as soon as Ulrod and the Duke apply pressure.