Separate from the question of how to physically depict sex, I always thought that the sex and relationships depicted in most of TNG, VOY, ENT, and, to a lesser extent, DS9, were deeply immature and unrealistic. It tended to be more about titillation than the various real manifestations of human sexuality, and most of the characters seemed to have the emotional maturity of a blueberry scone.