Ideally story and sex would be intertwined, neither a thinly veiled excuse for the other. Both uplifting one another into an experience that makes you laugh, cry, and cum.
When the story would be worse off without the sex, and the sex worse off without the story, that's when you know it's peak