There are any number of films, especially foreign films where it serves to drive the plot and is often times unpleasant. In cases like The Dreamers or Water Lillies the sex is a plot point and nothing more.