I'd like to argue that the sex drive of the future is somewhat different, but the reaction to Betazoid pheromes make it a hard case to make.

We witness the future equivalent of professional military service, and mostly follow officers on those ships. And almost always see them in uniform. Perhaps sex drive isn't different but we're witnessing workplace professionalism.

Yes, the univeral and unrealistic competence of the crew extends beyond technical skills to emotional ones--nobody ever abuses their authority over a failed relationship.

Edit: Am I saying it's impossible that it could become a reality? Maybe I'm being too pessimistic about human nature; but I think between military strucutre and being stuck in a tin can full time for years together, things would be messier. Maybe some sailors would like to chime in.

Many of us probably would. Myself however would much more likely go the other Barkley.and mutter "Computer, end programme!" every now and then.

A “hard” case you say?

Me, an asexual: "Heh. Skill issue."

Lamia gf you say?

Nah, not too pessimistic. Unless everyone is genetically modified (only through Dr. Bashir and the misfits do we know at least some were), everyone exists on a normal distribution. Lower Decks is arguably closer to what the humans would actually be like.

Lower Decks is the best version of Trek in my opinion.

It's messy.

I appreciate the episodes we got, maybe they'll reboot it.

Yes, Lower Decks introduces blatant nepotism into the Star Fleet canon as well.

Gotta pick up Season 3, soon.

There are more options than going full Barclay. You could go full Geordi only I'd just end up making another Moriarty rather than a Leah as a research partner. Or I make another me to collaborate with. Sex is great and all, but I have much better uses for a holodeck.

This is canonically true!

Hell good full sensory VR and I'm ready to check out of this reality.

Fantasies wasn’t were Barcley went wrong, it was involving coworkers without consent.

That was essentially the premise of Westworld (the series, not the films.)

Full Barclay? Nah, I’m going full Bortus.

While everyone is making jokes about sex, Barkley basically just used it as an escape. He created fake versions of his friends and coworkers that he could more easily be confident around, and you being asexual does not preclude you! We are all equally vulnerable yay~

Wait, am I supposed to get consent to fantasize about coworkers?

I always get permissions from coworkers before i wank to pictures of them. I feel this builds a better relationship.