We are at one of the parks almost weekly, and have never needed bug spray. I would think if you were staying in the campground, or doing one of the outdoor activities (fishing, boating, golfing, etc.) you would need it though.
I am glad you posted it though, because I have wondered why I keep seeing bug spray listed as a must have. Maybe we have just been lucky?