He might be overrated, but I still prefer him than many of Spidey's villains. Not because he looks like a badass, but just because he only wants one thing, and that's not a plan to become a crime boss, but just to destroy Spider-Man. Also why I liked both of his arcs in TSSM.
And I guess Sam Raimi had to be a genius to write a better story for Brock though. Because a good story for Eddie Brock would've made Venom better as a whole, as Raimi got Venom spot on for the most part(thirst of revenge, minus asking Sandy for help). I mean, what would've been better is if Venom attacked all three(Spider-Man, Harry Osborn and Sandman). It would've just showed how sick Venom has become, with trying to kill all three as two of them are in his way.
But, that's just my opinion, lol.
And what TheScarecrow said, that is very true...Spider-Man 3 did seem like a Burton/Schumacher Batman flick. And that's why it seems like Raimi will be sticking with a one-villain per-movie this time around, but hopefully we get more villain and less love angst. Which, that works well for Raimi, he can't seem to write anything good that has more than one villain. Sure, he only tried with one movie, but he only did a half-ass job.