I've been impressed with John Mayer.
Sada - Love Deluxe --> greatest hits CD, so highest density of good sexy songs, good background for a romaintic "my place" type event. Found to be one of the greatest and most subtle sexual lubricants.
Good intense, sexual CDs:
Enigma - MCXMC a.D.
Enigma - The Cross of Changes
Enigma - The Screen Behind the Mirrors (featured on Sliver, I believe)
I had a girlfriend who was into new age and Enya, Yanni and David Lanz (Christophori's Dream) fit the bill with her. I still have fond memories of those days when I hear that stuff.
Yeah, it depends on what kind of mood you're in, because, certainly NIN Closer would be good on occasion, and its fun on the dance floor.
