I personally find ZZ Top's "La Grange the all time best song song for knocking boots to. The change in ryythym is great.
Some Bob Marley, Gregory Issacs, or The Mars Volta always makes for some smooth bedroom tunes. I am a little wierd because I also like a little Primus amongst others to livin up the action.
Oh shit I forgot about all the great southern rock to set the mood. Being a Louisiana boy I do not see how I could forget! Right on wit the ZZ Top
Depending on the chick I could also go for some metal Yeaaaaah!