In a recent, rather silly discussion, someone pointed out that the crew were advised in "First Contact" to use their phaser rifles as clubs against the Borg, after the drones adapted to their settings.
This isn't exactly news.
It does suggest, however, that the way to beat the Borg is to go at them hand-to-hand. Someone else mentioned that this would expose the soldiers to nanoprobes, which is true, but.....
Picture this strategy: you attack the Borg in space by firing all of your weapons until the Collective adapts, then you kamikaze your ships into the cubes.
If your firing is able to knock down the enemy shields, you board the cubes instead of dive-bomb them. You board them with very large numbers of troops, wearing armor to protect them from nanoprobes, and bearing large "medieval can-opener" type weapons, maces, morning stars, etc.
Once aboard, you take the ship corridor by corridor, expecting to take massive casualties in the process. If any Borg nanoprobes get through someone's armor, you kill your own people, and keep on advancing.
Eventually, all the Borg are dead, the ship is yours, and you are way too tired, and mourning too many dead friends, to celebrate your victory. But at least niether you nor anyone you know is a drone.........
------------------
Slan agat!