This is actually the goal of all writers: keep the audience wanting more, in suspense, actively watching.
I just watched Endgame and about lost my shit laughing when there's this epic face of of 2 giant armies and the music gets loud and went "It'd be sooooo funny if the movie just cut to black right here for 20 seconds with full on silence."
I think it would heavily depend on your current readers and your own motives. If you have a story that's able to be freely changed and adjusted to suit the reader's whims and still fulfill your story, then congrats. I personally dislike that and won't pander to the "fans". They'll be stuck with the story however I've envisioned it. If that means one character gets molested, another dies, or another is raped, or another is bleeding all over and dying, then fine. They came in this far, they can stick it out or throw the book across the room. It's up to them.
It's your job to create the content. It's not your job to decide the readership's reaction.
Can you imagine what would happen if at the start of book 1 of Harry Potter, at the top of the first page of the first chapter it says that infamous troll line: {spoilers ahead} Dumbledoor dies.
Now what if that's at the start of book 2? Now you know who he is and are likely somewhat invested in him. Now you're just sitting, waiting, for him to die - constantly wondering how it'll happen.
The same thing happens with sex scenes. "There shall be sex!" you say, and then the reader is almost impatient, flipping through the pages, trying to see when it happens, is this it, this is it now right? And on and one they question. It's a bit like comical torture. Some readers will stick around for it, and some won't.