This question comes from comedies, right? In the movies the woman who is having the best sex of her life screams?
That's the movies. It's because it's funny to have people overhear her and because they can't show her actually having the best sex of her life, so the scream demonstrates it. It's a fictional device used by writers that doesn't reflect real life.