As a guy I always found it silly that in the middle of a life or death situation as soon a woman showed up, all Kirk's or Riker's attention turned to getting laid.
Kirk's attention rarely if ever turned to getting laid in a serious situation, the only time you may argue it was the case was in "Requiem for Methuselah" with him instantly falling in love with Reyna (which many people found implausible and out of character). Every other time, he was focused on his duty, even most of his flirtations and flings were at least partly manipulations in order to help his crew and mission (in that respect, Janeway followed in his footsteps in "Counterpoint"), and the one time when he was genuinely in love, he sacrificed the woman he loved in order to save the world. Any time when he actually seemed to be chasing tail (as in "Wolf in the Fold") was when he was off-duty.
It would be just as dumb seeing Janeway go up against the Borg...................but first Chakotay, I need sexual release.
Being married or in a serious relationship and with their partners close by, never stopped Miles O'Brien, Sisko, Kira, Jadzia, Worf, Odo from fighting the Dominion, and I don't think that anyone ever went "oh look, I first have to have sexual release, wait a moment" before an important mission. If being in a relationship was so detrimental to one's duty, why did Janeway allow Paris and Torres to retain their duties, instead of stripping them off their ranks and assigning their duties to someone else?
However, Kirk, Picard & Sisko didn't persue any sexual relationship with any of their staff either.
Actually, Picard did, in "Lessons", although he ended up deciding that he couldn't continue with it.
Is it fair for the Captain to be in a happy relationship when her entire crews loved ones are 75 light years away?
How does the captain not being in a happy relationship make the lives of the crew better? And how would her being in one hurt them in any way?

Is the implication that the crew are all jealous bastards who think "If I'm not happy, nobody is allowed to be?"
Does that mean that Torres and Paris should have never gotten together, gotten married and had a child, since many of the other crew didn't have their spouses or partners with them?
As far as I'm aware, Avery Brookes had a hand in Sisko's relationship because he wanted a character that bucked the stereotype of a Black man not being responsable parent and a worthy family man.
I thought it was that he was against Sisko leaving in the finale without a word to his family? Sisko didn't have to get involved with Kasidy to buck any stereotypes, I don't see how being a widower and a good single father prevented him from being a responsible parent and a worthy family man.
So there was a deep reasoning to with Sisko, just like there was with Mulgrew who didn't want Janeway treated like a Harlequin romance story. Is it so wrong for a woman to want her character to be strong & independant without needing a man to make he feel complete?
Hell no. But IMO it's wrong to imply that a woman can't be strong and independent if she is in a relationship.
Are the men who are in relationships with women weak and dependent and looking for a woman to make them complete?