I too don't believe in Superman or any other superhero being in
Star Trek, although
this crossover (and
this crossover) has happend, and
the heroes and their organization (plus
the heroes of the other crossover) fits into the
Star Trek universe quite well. I'd much rather have a crossover between certain sci fi universes and the Star Trek one (I'll mention those in a later post as soon as I can figure out what ones would fit on my own.)
You don't necessarily need Q to do this, any kind of hole in space/time would suffice (or an accidental use of slipstream-say, during an experiment by the Voyager crew to get them home-could do it too.)
IMHO,
Voyager's tech would be outclassed by the Colonial's and that of the Cylons, and
Voyager would be lucky to survive a Cylon attack by just one squadron of Cylon Raiders, let alone an attack by a Cylon basestar, even if Janeway were not to mull over intervening endlessly. Janeway would have to be on her toes militarily, and maybe get Seven to use some Borg tech to bolster
Voyager's systems so that the
Voyager crew would not get wasted by the Cylons (I'm of the belief that the energy weapons of both the Colonials and the Cylons is the of the same strength as that of Starfleet's, or of the same destructive power in any energy rating of the Klingons and the Romulans-and this also would also be the similar thing if a crossover were to happen with
Star Wars, and a Federation ship were to face the Empire or the First Order-I doubt that
any Starfleet ship, including the Galaxy, Ambassador, Excelsior, or Nebula classes, could just overpower the First Order or the Empire [and I'm a fan of both franchises.])
BTW, here's a size comparison chart of all the various sci-fi universes's ships:
As I said, I don't see the Federation Starfleet posing a danger to anybody from the
Star Wars or the classic (1978-1979)
Battlestar Galactica universe (of course, a Starfleet ship
could beat an Imperial/First Order one, or a Cylon fighter squadron/Basestar, but the commander has to be
very, very good at naval warfare tactics. (and then, there's always
this ship...

)
Those are interesting questions to ponder. Of course,
IF Janeway does decide to commit to fighting the Cylons because she and Chakotey believes that they're nothing but a bunch of bullies, everything I said about unconventional naval tactics and tech advances/enhancements for
Voyager will have to be dealt with.
You do realize that size of ships doesn't dictate how powerful they will be.
We have on-screen evidence that 24th century starships from the Federation would handily beat Galactica and SW universe ships (probably even Andromeda universe ships and most in Stargate).
When it comes to firepower, the Federation was seen using multi gigaton to teraton weaponry - these are the same people that created a Genesis device which was capable of creating a planet in the 23rd century.
Star Wars has 0 on-screen canonical data indicating its anywhere close to gigaton level firepower (for the ISD or any other ships - plus the novels are NOT canon)... in fact, all canonical evidence suggests barely low megaton to kiloton capacity if anything else.
Only the Death Star was a massive station capable of actually blowing up planets, and that thing needed a ridiculous amount of machinery on a large scale.
The Federation needs just 1 modified torpedo to also destroy a planet if they wish.
Federation ships employ a wide array of subspace technologies to augment their weapons beyond what simple M/AM reactions allow - plus, we've seen them using those weapons at extreme ranges (about 300 000 km for torpedoes and about 150 000 km for phasers - that's for the Nebula class starship - the galaxy class was likely featuring more advanced weapons).
Even the Andromeda ascendant barely comes close with its enhancements (except in maybe weapons range).
But also, the Andromeda comes from a reality in which space-faring civilizations don't use FTL communications, no transporters (both of which remained a proverbial 'dream' through the series)... and directed energy weapons are seldom reserved for more advanced species like the Magog.
Plus, phasers can easily intercept incoming missiles like those from 300 000 km away (in other words, the Andromeda's weapons don't pose a threat).
From canonical data alone, the Trek universe Federation easily wields technologies that surpass most things from Wars, Galactica and Andromeda.
Also, I would find it incredulous that the UFP with its advanced understanding of energy manipulation and conversion (with replicators and transporters) would be outmatched by those 3 different universes that don't have those technologies.
Hyperdrive doesn't have to be anything fast, especially if we're talking about a micro-galaxy that's extremely dense and has a radius of 300 Ly's... at which point Hyperdrive would need to be as fast as Warp 9.9 (21 473 times LS) to go from one end of it to the other in 5 days - also, Warp was seen to be capable of much faster velocities.
Plus, even if its much faster, the Wars galaxy looks to be primitive at large due to its use of an outdated socio-economic model.
Galactica and Andromeda may have an advantage with jumping technology and Slipstream.
However, Voyager also brought back more advanced version of Slipstream (enhanced with Borg technology) which allowed a speed of 10 000 Ly's in 1 minute (its very likely SF with its larger assortment of resources would be able to stabilize it - but we know the engine was tested molecule by molecule, which makes it ridiculous that it would result in problems, and the only issue here is the writers wanted to keep the ship in the DQ - otherwise, no more show).
And while that velocity is probably still slower than 'slipstream' from Andromeda, its easily fast enough to get from Milky Way to Andromeda galaxy in about 4 hrs of travel... and it likely beats the jumping tech from Galactica.
Galactica and Cylons use primitive weapons technologies such as nuclear bombs.
Photon torpedoes easily go into the 500 megaton range in early TNG, can be used at FTL, have tracking capabilities, and can be equipped with shields... but we've also seen phasers burrowing through thousands of km of planetary crust in seconds (which requires gigaton level of firepower), along with the enterprise-D removing the icy exterior of an ateroid that formed around the alien archive (in which Worf used 10% yield - resulting in about 15-25 gigatons per second).
The Defiant by comparison had enough firepower to turn the Founder homeworld into a cinder... and a 30 ship fleet of Romulans and Cardassian warships induced 30% of planetary crust in an opening salvo (suggesting terraton level weapons - which even the Stargate ships didn't really have - except possibly the Asgard - they might be able to match the UFP in terms of weapons - they certainly surpass it in FTL speed, but weapons would be more tricky... plasma beam weapons behave more like phasers if anything else in damage and effect).
I'm sorry, but neither Wars, not Andromeda, and certainly not Galactica have been witnessed to posses anything of this caliber (at least not on their main capital ships which are used at large).
As for sun-killer torpedoes from Andromeda... meh, the Federation learned a long time ago how to destroy a star... and we've seen it happen in TNG with a trilithium torpedo... twice... but the Federation doesn't go around blowing up stars... and just because they can, doesn't mean they should (nor does it say they are weak on technological basis if they don't - they simply prefer other less destructive methodologies).
For that matter, Farscape is also incredibly weak technologically (I mean the Peacekeepers and the Scarrans).