1) Doc Ock/Vulture: Both work perfectly for the film they are in. They both are three dimensional, get some great moments, have well fleshed out motivations and make interesting foils to Peter (Ock is a version of Peter who never accepted responsibility for Ben's death, Vulture is a fellow "little man" who is trying to get by in a world ruled by godlike heroes). These are two of the most well done live action super villains, IMO.
2) Green Goblin (Dafoe): Great performance and he gets some excellent and memorable moments, but the script does him a disservice by giving him little in the way of motivation or depth. He's a mediocre villain on paper that was elevated by the master-class actor who played him.
3) Green Goblin(Franco): This is where the quality starts to decline. Harry should have been the main baddie of SM3, but Raimi was more interested in Sandman and the studio in Venom, so Harry got he shaft. A shame, because Franco gives a truly creepy performance and he gets a few good scenes. His "redemption" is rushed and hokey and the fact that his master plan is to simply split Harry and MJ up is embarrassing, but he's still on of the better things about an otherwise ****y movie.
4) Tinkerer: Churus gave a pretty fun performance with this guy. I liked how OCD he was, and I enjoyed him as a sort of evil Ned Leeds in the way that he geeked out about all of the tech he was working with. I seriously hope he continues to supply Spider-Man villains with tech in the sequels.
5) Shocker(Woodbine): While Shocker isn't given much to do, what we got of him feels straight of the page from the classic comics Shocker. He's a consummate professional, seems to enjoy his work, and is pretty level headed (once Iron Man shows up to save the ferry, he tries to quit, which makes him pretty genre savy). He got a few cool moments (beating up Spider-man with the busses, jumping on the Vulture's back to fly away from the Ferry) and Woodbine gave him a cool demeanor and presence that was pretty entertaining ("I didn't want to use this at first, but DAYUMN"). Serves his role as well as he could have and I hope he shows up to plunder the webbed again in future installments.
6) The Lizard: The Lizard is done pretty well, but the absence of his family and a lack of clarity on how his apparent split personality worked makes him feel like a generic mad scientist, which really feels like a waste of one of Spidey's most tragic foes. However, I like that they went all out with the comic-booky stuff, such as the lizard army and whatnot, even if it clashed wth an otherwise grounded film. He's ranked below Shocker because I feel like that character was a spot on adaptation, whereas there is much wasted potential with the Lizard.
7) Shocker(Marshall-Green): While this character got a limited screen time, I feel like he had a pretty entertaining personality and I would have liked to see more of him. He seemed really enthused about being a super villain, which was fun. I wish he got more screen time. The only reason he's higher than the rest is because he doesn't actively piss me off at all.
8) Green Goblin(Dane DeHaan): While the character is awfully written, DeHaan is entertaining enough to be watchable. His motivations were terrible though, and he quickly became a generic baddie with a grudge against Spider-Man, throwing away any potential depth he seemed to have in the beginning. Plus, he looked terrible in that Goblin get up. I feel sorry for the Harry Osborn character. He's had two shots at being the main villain in these movies and both were disappointing.
9) Venom: This character could have been better with more screen time, but he feels like a cartoon villain. Praying to god to kill Peter Parker? Please. However, the direction of making him an anti-Peter is interesting, and having a completely evil monster felt fresh in a film series of (sometimes poor attempts at) sympathetic villains.
10) Electro: Pretty terribly cartoony character. Not much to say here. The other two just annoy me more.
11) Rhino: Yeah, he's pretty awful. Nothing much to say here.
12) Sandman: Oooh boy does this character grind my gears. First you have the terrible origin retcon. Then you have the fact that his presence forced a more interesting villain (Harry) to the sidelines. Then you have the worst thing; the fact that Flint Marko may be the most morally repugnant human being in the Raimi films, in spite of the fact that the movie seems to see him as a tragic anti-hero. Marko has a good sob story, sure, but the character loses my sympathy when he engages in bank robberies that seem to kill or injure several security guards and cops. Then he works with Venom to kidnap an innocent young woman and kills several swat officers to do so. THEN, after spending two hours either killing or injuring every other person he has interacted with in the film, Spider-Man feels it justified to let this serial mudering bank robber go free. Every other villain had some excuse for what they were doing. Green Goblin was driven insane by the serum. Octavius was partially under the control of his tentacles' AI. Harry never actually targeted innocents and Venom was being influenced by the symbiote. Marko was in full control of his actions every time he attacked or killed someone. I just find him to be an unlikable monster and I HATE how the movie seems to pride itself on how likable it thinks he is. Vulture had a sympathetic motivation as well, but at the end of the day the movie still clearly thought of him as a villain. Sandman is maybe the worst part of SM3 for me. Well, aside from the dancing.
Just my two cents.