I think the recent Batman movies are a good example of absolutely stupid looking comic book villains that can look AMAZING on screen. Really now, Scarecrow? That shit is just lame, but on screen they still made him awesome. We need not even mention the Joker.
I'm not the hugest Spider-Man fan, but if he wants The Lizard as his villain, let him have the damn Lizard. Studios suck.