I definitely agree with some that have been listed already - Wicked Game and Nights in White Satin in particular. But the ones that spring most to mind are
Justify My Love - Madonna (shocked that nobody has named it yet, unless I've overlooked it)
Tunnel O'Love - Walter Egan, and no I'm not kidding, that song is hot!
Anytime you want me to do a little chore
Don't you know I'm waiting down at your back door
Indicate the feeling that you think is fine
And you know your wish will soon be mine
Tunnel O'love Tunnel O'Love
Ooh baby, take me for a ride
Tunnel O'Love Tunnel O'Love
Ooh mama, take me inside
Ooh you're such a comfort
Ooh you're such a thrill
Ooh the way you hold me when you say you will
I'm like a volcano, ready to erupt
Baby when you treat me to your sweet sweet stuff
Tunnel O'love Tunnel O'Love
Ooh baby, take me for a ride
Tunnel O'Love Tunnel O'Love
Ooh mama, take me inside
Dancing down the street to the tune in my head
Thinking of the nights spent in your warm bed
I'm anticipating, watching time go by
To get some stimulating between your thighs
Tunnel O'love Tunnel O'Love
Ooh baby, take me for a ride
Tunnel O'Love Tunnel O'Love
Ooh mama, take me inside... 