Personally I'd always sacrifice sex to have a more rewarding conclusion to a story or to drive a story ahead in a meaningful way. The temptation to end on a crowd pleasing sex scene is certainly there, but I feel like a purely character driven or emotional coda or epilogue is always a good call...