Good question, and of course it all depends.
Are you talking "big box" to describe "big box" retailers, or did you mean something else?
I would answer yes, they are "good" in general, but their collateral damages of traffic increases and crime attraction could outweigh the "good."
It all depends.
Also, if the retailer is incongruent with some of the core demographics of the area, and does not attract "neighbors," only more car traffic from non-neighbors, then the stigma of being a fish out of water can outweigh some of the "good" too.