i am entertained by both of the universes, but the federation of Star Trek just plain has superior technology by several orders of magnitude. the federation inadvertently creates planet and solar system destroying materials fairly routinely that generally are meant to have some higher scientific purpose, but could 100% be weaponized... as is often the threat when some antagonist finds out about them so their development is tightly controlled.

• Genesis Device
• Red Matter

those two jumped into my mind first, but i'm sure every season of TOS and TNG have some doomsday b.s.

meanwhile, the death star took like generations of theorizing and development by like the smartest guy they could find, a completely unique and entire planet's worth of extremely rare, ancient magic materials, and multiple planets of slave labor to make a single doomsday weapon.

the regular armaments the federation tools around with are basically like the space faring equivalent of what the Garda Síochána roll around with in Ireland, because the whole point is find diplomatic solutions to every conflict and not be a cause for escalation. so like space pepper spray, space batons, and space handcuffs. none of that stuff did anything to the borg except when the borg attacked earth and they put the entire defensive armada on it. generally, they always ended up using some weird ad hoc move like hijacking the hive consciousness or whatever. the borg cubes could travel at warp speeds faster than the flagship of the federation.

there is absolutely no chance "hyperspace" is comparable to Star Trek warp propulsion, because in ST they can use it to do time travel.

star wars fandom weirdos usually try to insist that the size of star wars crafts is somehow correlated with their capability. to me, the imperial fleet is more like the absurd dreadnoughts of the late 19th and early 20th century, that were these relics of a mindset that was obsessed with having the biggest guns firing the biggest shells since that was the big scary technology: the ability to fire a giant shell from far away. in star wars every weapon is basically a laser beam and the variability is scale. even the capital ships and death star are just firing really huge lasers. their whole power is based around their unchallenged control of key areas. in Andor it's characterized as a lazy regime that invites rebellion because it is too arrogant to imagine being opposed.

in ST they are always reprograming torpedos and probes to deliver weird ass payloads of bizarre energy, nanite materials or biologicals. the technology and mindset of the star wars deal always felt like it would have been part of the Eugenics Wars.... some supremacist bozos running around doing lots of genocide and slaughtering, but essentially primitive and limited compared to what the federation science would develop centuries later, after the dark ages.

if there were an honest Borg Cube vs. Death Star, the death star wouldn't even understand what the cube was and be paralyzed by incomprehension when it just sort of drifted there and didn't open fire, engage, or even seem to respond. a handful of drones would be "captured" and brought on board to clumsily interrogate, resulting in the entire station being assimilated in like 36 hours lol. the only weird counter-shit SW has is their space wizards and i bet like one space wizard could kill like 3 borg before the borg would adapt and then assimilate the wizard. then there's Borg Space Wizards around, fuckin' shit up. that would be the most interesting legacy of Borg Cube vs. Moon Laser Base 1969.