Re: Troi & Data Were Sleeping Together, and Other Stories
I think you can count the number of truly intimate moments Riker/Troi and Picard/Crusher each share on one hand.
The TNG and VOY crews really were sexually repressed overall.
"I was never a Star Trek fan." J.J. Abrams