i actually thought Dr No was the worst, possibly because it was cheaply done.
For the absolutely worst special effects, From Russia With Love, it had to be the boat chase when Robert Shaw was being chased by Bond. A speeded up peice of film, it just looked bad.