1 or two planets no not effective.
But we are talking the domion here who would go out there way to try and infect as much the gamma quadrent as possible. So with borg losses in trying to take the domion being high they would have trouble getting easy drone replacements without sending them from other places.
And im sure section 31 would try and infect most the alpha/beta quadren
Its a weapon for the long run.