I was once camping with friends on the bank of a beautiful mountain lake, enjoying the serenity of the place. One of us had brought his wife and three-year old kid. As we were falling asleep, a biker in a tent next to our tents in the campground started banging his girlfriends -- yes, at least two of them. Loudly! Let's just say we all felt like we were right there with them. Or they with us. I need to turn that one into a story some day. But I digress...
Dwelling too much on the setting can easily distract from the story -- in one of my stories I got rather carried away describing a scuba diving trip because I wanted to give readers who'd never been diving a feel for what it's like. I went overboard, so to speak. Less is more. A little bit goes a long way. Doling it out in teaspoon quantities and then sprinkling more throughout the story, as needed, is the way to go. Some of the best writers of thrillers and spy novels, for example Raymond Chandler or John Le CarrΓ© or Len Deighton, are masters at using setting as a character in the story. Their settings can be gray and murky and smoky, and so realistic you can smell the cigarettes on the fingers of a shady character or the sex in the air at a club where a burn is in progress. They use setting to service the plot. I meant, to further the plot!
In her novel Out of Africa one of my favorite writers, Isak Dinesen, described her coffee plantation in the African wilderness so well that I could hear the rustle of the wind through the tall savannah grass and dream I was there, sharing gin and tonics with her and her other guests on the porch of her house. She was truly poetic in her descriptions. But those same descriptions would be much too distracting in a thriller or mystery novel, or in many erotic stories. I would skip right over them to get to the good parts instead of savoring them, rolling them on my tongue like a piece of slow-melting hard candy.
So choose your setting wisely, describe it sparingly, but make it vivid. And let the characters loose to have their sex and eat it, too. Cake! I meant cake!