You're completely in the minority on this one, Phoenix Dark. Mysterio has always been a joke and if you honestly prefer him to Sandman, then you don't really like Spider-Man. And if you think Mysterio wouldn't be CG effects, I laugh.
They should really stop the series, because it'll start running on fumes. Once Peter Parker got Mary Jane in the comics, nobody really cared about his personal life. He just started spewing one-liners while fighting the same villains... again and again.
That's why I laugh when comic book fans and film geeks complain that Burton and Raimi kill off too many villains. As if they should be allowed to return in future sequels. Nobody wants that. Film is a completely different medium and it's outright distinguished mentally-challenged to think a franchise will survive to a point where they will bring back villains (unless it's planned ahead of time, like Joker in the next two Batman installments). Even if they did, it would be just be more of the same, which is the problem with American comic books these days. Who can take these threats seriously if they'll just return and be defeated over and over?
The most interesting times in Spidey history has always been his high school and college years, because after that, the character has been stuck in a time warp to continue his villain-of-the-week shenanigans. There's no end game. And that's boring.