Here's a recommendation for you: Don't Look Now. It features a vividly explicit sex scene that's absolutely vital to the plot. It's one of my all-time favourite films.

More here, if you're interested:

Sex, Grief, Fear, Loss: The Enduring Power of Don’t Look Now | Fanfare