I do hope that the show makes the Borg a big threat again. And I think the best way to do that would be to show that the Borg have adapted to the transphasic torpedo and ablative armor tech that Voyager brought back. After all, the greatest strength of the Borg is their ability to adapt quickly. Having Starfleet easily defeat a single Borg cube would be a terrible idea because it would wussify the Borg even more. A single Borg cube should be very difficult to defeat. It should require a large fleet of ships to even have a chance at stopping it. That would make the Borg menacing again. And in terms of ground combat, Borg drones should be like zombies that just keep coming and coming and are very difficult to stop. After all, the Borg are basically technological zombies.