In my view, the plot is the most important element. The context in which the sexual activity takes place is far more important (to me, anyway) than the sexual activity itself.
Not that I object to a well written sex scene, of course. But it's the context which makes it work for me. Or not.