I was just watching "Who Mourns for Adonis" and was wondering how a Borg Cube would fare against Apollo and that big space hand of his. A cube is considerably larger than the Enterprise so there may be some difficulty there. And if drones beamed down to the planet would Apollo be able to stop them? Or would the Borg adapt to him? Who would win in a battle between Apollo and a Borg Cube?
The crew's counter strategy was to home in on his power source and hit it with phasers, seems like the sort of thing the borg would be likely to try. I'm doubtful that they would fail to recognise it for the alien tech it was.
Depend if the Borg cube has enough time to find the power source and assimilate it. Apollo would want worshippers and might delay destroying it until it was too late.
Apollo isn't that hard to beat. The Borg would have him. It's possible the collective might of the whole Greek god ensemble might have thrown them back tho'. I'd also like to be the fly on the wall if Apollo met with the BQ personally.
It depends how much he was holding back. "APOLLO: But you're of the same nature. I could sweep you out of existence with a wave of my hand and bring you back again. I can give life or death. What else does mankind demand of its gods? ". If Apollo can wave his hand and wipe out all of the borg then he should win easily. But his efforts to stop the Enterprise from destroying the temple were disappointing ( a few mostly harmless lightning bolts with Apollo yelling "stop!" a lot).
Rather my point, when tested against the Ent's weapons, his tech floundered badly and he had little by way of defence and bear in mind that's a Connie. Scale that attack up a few orders of magnitude and its hard to see why the Borg would struggle.
I got the impression he was an alien with advanced tech, he wasn't a Q or anything-however his talk about fading into the wind and not dying as humans do implied to me he(and his fellow Olympians) either had a very different biology or were connected at least tangentially to the realm of the metaphysical.
Apollo had a small flair for showmanship, but I think he was more Ardra than Q. I thought his green space hand was revealed to be a dressed up force field when scanned by the Enterprise's sensors. I can't imagine a force field would give the Borg much of a problem. The Borg might have been interested in the extra, energy-conducting organ McCoy detected in Apollo's chest, assuming it was something they hadn't seen before. A more interesting contest might be Apollo vs Trelane. They could each throw a tantrum when things didn't work out the way they wanted.
Greysun is pretty close to the mark I think, it would be very easy to lump Apollo in with Q, Trelayne, the Prophets, any number of TOS "gods", but doing so would be erroneous. He is portrayed as being, if not an outright fraud, then at the very least rather fond of posturing and giving the impression of far greater abilities than he actually possesses. He is not omnipotent or demonstratably telepathic, telekinetic, etc, he simply has access to a technological power which in some ways surpasses 23rd century federation tech. Even the mysterious green hand is basically a fairly powerful tractor beam, which displays no feats beyond those of the equivalent Borg device. It holds a Constitution class, the Borg tractors can hold a Galaxy class. His power source is insufficiently shielded to cope with 23rd century starship phasers, which in turn are no match for their Borg counterparts. His attacks are of ambiguous effectiveness in return and clearly would not scrape a cube. So, on the basis of portrayed abilities and weaknesses, the Borg all day and that's without breaking a sweat.