One of my favorite movies, "5 To 7", is a story of a 24-year old unmarried Jewish man who falls in love with a 33-year old married French woman and has an affair with her in NYC. It is so well done that it had me laughing and crying, especially because of the culture conflict between the two and how the whole affair became so extremely emotional.
The movie is mostly dialogue, very witty, not at all an action movie, and it is very much for adults. There's no nudity and the language isn't bad at all, so kids could be in the room and they'd probably just fall asleep because they're not at all likely to relate.
Needless to say, I loved the movie, have seen it twice, and probably will see it again-- it's that well done.