Venom was killed; no off-screen death, he obliterated on-screen never to be seen again. I felt so bad for Topher Grace in the role; he didn't look the part, he didn't pull off the character acting-wise, it was depressing seeing such a huge Spider-Man fan sell out on a thankless role.
Sandman is alive yes, but his escape was total bull. Talk about some of the worst writing ever; I felt bad Thomas Haden Church gave his best with that shoddy material.
Harry died a hero; that's not the Harry I know. Franco played him amazingly though.
Electro is no more dead than Lizard, he is in containment. I have already said the writing was horrible for Electro; it was a worse-written Riddler from BF, and Jamie Foxx's "acting" is still absent.
Rhino, while a joke, is still a threat and was always only meant to be the bookend villain for the movie, I don't know what people were expecting. Giammati did the role as well as it could have been done.
Harry is 'dying' the same way Norman 'died'; They may have some sort of disease, but the radiated spider venom extract most definitely kept them alive, and Harry isn't dying. The role was written very well despite some minor complaints of people calling him a hipster; in this day and age, his character would be a hipster, and it took nothing away from his comic incarnation. Dane DeHaan owned the role.
I will take the better written and represented ASM2 villains over the SM3 villains any day.