Gerald’s Game perhaps? I mean it’s not a sexy sex scene but it really informs us about a character.

Of course many sex scenes are unnecessary, just there to titillate.