Obviously nobody on the Enterprise ever watched "Alien".
Flame- throwers baby!
None of the away teams ever heard of hand grenades,claymore mines,any of that shit.
When it comes to the Borg,there has been an unending supply of bad,lazy thinking about just how the crew will actually engage their deadliest,most lethal foe.It seems the writers cannot allow Starfleet to look anything like a competent fighting force.
As for shooting at an individual drones shield,shoot at the floor in front of it,the ceiling above,all that exposed machinery...