Then the ground PvP maps would be changed into WW1 style moonscapes and LRM-20s will be streaking all across the sky.

Just like in Mechwarrior 4

"Assimilate this!"

*Sollvax demolishes Borg Probe on Defera with Clan UAC20*

My Caitian (Ol' Captain Scream-N-Leap) is kitted for hand to hand, with a MkXII Nausicaan sword and the MACO battle rifle. He's at his best surrounded by Borg, when he can use Sweeping Strikes III and clock several of them at once. If I can aggro a bunch of them and keep them in one area, an engineer can drop a brick on them from orbit and usually half of them go down, the rest is cleanup on Aisle 5.

"official universe" novels are canon (as in the ones written by the same people as the series)
They have the words Official universe stamped on the spine

Personally I'd use an Arrow IV or twin Heavy Gauss...

Personally Id rather use a genetically modified flesh eating virus

Note the whole "skipping shields" part of melee. It does carve them up, if you can survive/avoid assimilation. Problem is, that's a very big IF. Borg drones don't feel pain or deviate from their objective until they're dead. You lop off one arm, they smash your ribcage in with the other one without even blinking. And you never fight just one drone. Close range combat with the Borg is suicidal no matter how you try to butter it up.

And that's not even starting on the whole "bringing a knife to a gunfight" thing - these Borg are armed with energy weapons of their own. Notice how many Klingons die in the first battle of DS9 before even one gets to swing his bat'leth? Being a melee specialist may look cool, but in a world where someone on the other side of the room can push a button and kill you instantly, it's foolhardy to trust your life to a blade.

Assimilation can be innoculated against (nano vrs nano) then the borg can be fought mano to mano (jokeo )

Well, my one custom alien that would engage borg in hand to hand can easily handle a crowd.

Also, I never said it's be an effective only weapon. However, like Worf did in First Contact, keeping a blade with a decent length on it as a ready backup is good.

Also, for Borg to assimilate you, they have to have hands. As with most melee weapons I know of, you wouldn't be hugging them unless you did an old fashioned stab in gut. One can swing a lirpa at a good distance and lop off the drone's head, which would be the primary target.

Canon? Maybe. Official canon? No.

Official canon is what was seen on screen. Nothing else - books, games, comics, or tech manuals - counts.

Screen isn't always canon (diabolical movie attrocity)