The bronto stampede in Kong '05 has to be up there. Horrible horrible effects.
I didn't think the bronto stampede was terrible, just not up to the level the effects reached in the rest of the film. Kong himself was a masterpiece.