The negativity is understandable, I'm just choosing to be positive about it, at least until release day.
I think the special effects in the first three were overall pretty decent, in the first Spider-Man most shots worked, although some were slightly rubbery, but for every rubbery shot there was an two awesome ones. Example of a good one, Spider-Man gets blown back through a brick wall by an explosion seen from behind, example of a bad one from the very same scene, just moments after The Green Goblin jumps from his glider and lands before Spider-Man; it looks "off", a tad too unconvincing.
In the second Spider-Man's swinging looked amazing, the effects were tremendous, check out the train sequence, it is mind blowing.
But on the third they must have concentrated on Sandman too much because there was a return of the rubber Spider-Man, perhaps the departure of John Dykstra was also to blame.
And as for the new one; the effects look pretty damn good. However, most of the action seems to be set at night, I think it's easier to make CGI look good in the dark as opposed to the often harsh sunlight of Raimi's flicks. Plus, alhough it's not my favourite fight from Raimi's trilogy, Webb has his work cut out if he's hoping to best that train sequence because damn... it was sweet.