It’s in the end of the last Dark Tower book. What he wrote can be reworded as ‘Do you have sex only for the orgasm alone, or for the whole process of it?’. And it wasn’t the weirdest part of said series.