Star Trek is a USA product so from one side bring USA
people dreams, like exploration, journey etc BUT also USA ruling class willing. For instance
formally in Star Trek people have surpassed capitalism and tech reach a point that anyone can have almost anything to live a satisfactory life following just their will,
formally, in practice Star Trek is designed around "the fleet", like the USA are designed about "the army" (in the broad sense), the sea from witch the USA project their power is the space in ST, people are not at all free, they only think to be. Like most USA Citizens think the USA is between the most free country in the world refusing the substantial fact that there is no real democracy there but just a classic oligarchic corporatocracy that use a formal democracy as a Barnum circle to rule.
Star Trek recognize some other countries like Vulcanians that probably are Europeans, more advanced in tech and civil terms but subject of the newly born "federation" and the Klingon who are probably the Russians, sometimes enemies sometimes friends. The Borg represent the USA ruling class hate and fear of socialism because just before the absurd choice of representing a Borg Queen the Borg are a perfect society where all decisions are made by the people (the collective) and all citizens are really equal. They are represented as powerful, because conservative élites know that a social society is far more innovative than any others, but as terrible enemies, so terrible that federation officers can board their cubes without being assaulted, free to move and look around just until they do something against the Borg, while a stranger boarding the Enterprise is an intruder, need to be contained and questioned etc.
Not only: see how clean, aseptic, against sexuality, rigid federation officers appear, that's a classic USA and even more British characteristic like when at international sport events you see athletes from all around the world in casual dress and those from USA (a bit) and UK (much more) move in suit and tie regardless of the climate, or how USA and UK lay out their dream homes, or how sexuality is (obviously) present but is a kind of tabu in social talks respect of west Europe for instance.
That's dos not make ST a bad series, I like it, I have seen most of it many times, but when you see it take into account not just special effect and formal "good points" shown, see the others elements, look under the trees :-)
BTW personally I'd like much more to be a Borg on a cube, of course without any Borg Queen, than being framed by a fleet who put appearance before the substance... And I like the idea of exploring around with a moving house, armed enough to defend myself but not (really) to offend.