Lust, Caution, a Chinese thriller directed by Ang Lee and set during the Japanese occupation in the forties, has some great hot scenes in it. Softcore porn level, in fact. Good spy flick, too.
Helps that Tang Wei, the female lead, is seriously hot. It was her first film and got her blacklisted in China because of the sex scenes and her performance in them (but she's came back after a few years).