Sex is sex. Its use depends on the setting, plot, and characters. It can be a great tool for good writers and artists, or it can be pointless and be used to fuel free advertising via fox.
If it works, it phases me about as much as say, shooting someone would in a war game.