Seven is always the sexbot. She’s given more to do as they realize how well Ryan did with anything they gave her, but she’s never out of a skintight outfit, telling Harry to get out of his clothes, having her body violated in one form or another, needing someone to tell her how to date, falling in love with Chakotay for reasons, wrestling the Rock and somehow not getting liquified… She was brought on for one reason, serendipity notwithstanding.
This one's complex... (I don't remember much of 7, save for her being rescued from the Borg and her reclaiming her humanity in a number of genuinely interesting plot elements, and being more relatable than Data.)
Of all the ladies given skimpier outfits than the revealing uniform (esp. seasons 1 & 2), at least Seven had an interesting explanation involving what the Borg technology did to her epidermal layer. Troi, T'Pol, and others... eh, not so much, and why would Troi not be in proper uniform doing her professional work anyhow? May as well have her screeching in every episode "gag me with a spoon!" and other valleyspeak contemporary for the era, yuck... but I digress, odd but true.
As for personality, it juuuuuuuuust about works as Seven/Annika had been robbed of her humanity for the majority of her life (since age 5, was it?) as well as the human culture that 24th century was said to have exuded.
Serendipity (not always related to "plot armor") is a possibility as well, though The Rock's inclusion was a sappy sweeps weeks ratings grab for a story that could have been a lot better than "
American Gladiators Shoehorned In Space" (for which the acronym is "A.S.S.", go figure). Indeed, there's a few episodes of
Family Feud of the time where American Gladiators actors were featured and they play it up for every laugh as possible...
as for body violation, it was a time-tested Trek trope at that point.
Kes I barely considered and if anything think the writers were too juvenile to know how to make more of the possibilities for love triangles on the tiny ship. Kes, Neelix, Tom, the Doctor, others….hell, Harry and B’Elanna and B’Elanna and Chakotay seemed to be possibilities earlier on as well. Also just the boys and the Delaney Sisters, various aliens of the week, situations they find themselves in. It’s subtle but prevalent throughout the series. Every gimmick is one a male writer for a scifi series geared toward adolescent boys would come up with. You notice it more on the rewatch.
Trek never was good at love triangles, the best by far was Troi/Riker as past-tense and the second-best was the Harry escapade "The Disease", which got so much wrong on so many levels when otherwise not being underwhelming... The show's very theme of "to seek out new life and new civilizations" is contrary to being navel-gazing on the attempted copulation of main crewmembers with one another. Let "90210" or "One Tree Hill" do that, they don't focus on exploring the cosmos.
Hell, the concept of a Borg Queen is fear of mother. “No, no, that’s because they needed someone to personify the Borg,” you say? The apex of the Borg were BoBW, no Queen in sight. Certainly not one who boinks Data and has a very special relationship with Seven because reasons.
^^, 100% that. It's a bit icky and yucky and NOT because prepubescent people might or might not be watching the show (since, yep, more than one reason can exist and Trek showed us some new reasons, if not unintentionally.)
Aso note how "Scorpion" also lacks the Queen and not for a very long time were the Borg proper scary* again... but makes a comeback in "Dark Frontier" because...
exciting. Right?
* to be fair, making them proper scary all the time dilutes them faster, so having a one-off splinter group (even if the dialogue didn't sell it perfectly) with the events of "I, Borg" and "Descent" (part one, anyway) led to some interesting ideas and, indeed, a frightening inversion... which never got explored because the show was so far into navel-gazing that they brought back Lore as a sweeps week event instead of something with more substance, and there's plenty involving ruthless killer Borg as opposed to their regular gestalt routine. Oh well, at least the Bros of Soong will conquer all, moo-hahaha as they milk it to the farm and back, ugh...
And they repeated it with the Sphere Builders being all women. Not, say, the Malon or the Sulibon or whomever, but the Big Bads. …Mommy issues.
I don't recall the Sphere Builders, which episode? (Was it ENT?) Were the Malon and Suliban in ENT?