Question: are the borg ever destroyed?
Answer: The Borg weren't destroyed, but rather forever changed and went away with their Caelier brethren. Not only has the Borg Queen been destroyed at least twice (in First Contact and Endgame), another version appeared in Voyager, "Dark Frontier" and "Unimatrix Zero".