My favorite erotic movie is "Damage" with Juliette Binoche and Jeremy Irons. It's about obsession and NO ONE does obsession better than Jeremy Irons. The sex scenes are VERY passionate and erotic. The ending is a catastrophe.
Roger Ebert gave it four stars when it came out in 1993. Here's his review: Damage