agree with you 100%, relationships between the sexes goes nowhere, even the Troi and Riker relationship was a joke, or even worse was the Picard and Crusher relationship, talk about on again off again, once a season dinners they had with each other. Thats why Kirk was the best, if you were a girl no matter the color or race he was gonna try and get into your pants, his objective was to explore new worlds though I am not sure if it was space he was always looking forward to exploring.
I forgot about the kim and 7 of 9 incident, maybe because that show was just so awful that I am doing everything in my power to forget about it.