Dead-Air's mentioning of Dead Ringers spurred me into seeing it. I loved it!! Yeah, the bondage scene is brief but good. I'd also really enjoyed the sex in A History of Violence, very memorable.
I'm now hunting down The Fly, which I somehow havent seen since I played it over and over as a kid.