It's just done poorly very often and shoehorned into situations it doesn't belong.

There may be some prudish people but I'm not offended if I read an out of place sex scene, I'm just a little bored.

We live in a world with the internet and anything sexy directly at your fingertips. Incorporating a sex scene just because has lost it's relevance and steaminess.