Not really what you're looking for (i think) but i thought the nudity in watchmen was used to excellent effect. One time when I (controversially) think it didn't work was surprisingly in
Cronenberg's Eastern Promises. Maybe I need to see it again, and I gues it fit with the same theme as his tattoos, but generally i thought it was quite badly handled and not particularly tense. That's just me ...