Thanks to Michelle, I now know that the town of Enterprise, Alabama, has a monument honoring the boll weevil.
The best write-up on it I've found so far is presented by Shelley Brigman, who worked as a newspaper reporter in that area.
The town erected the monument after the boll weevil forced farmers in the area to plant crops other than cotton. Becoming less reliant on cotton turned out to be a good thing. Hence, the tribute to the pest that started the search for better ways to make a living.