Sandman was, aside from the special effects, pretty bad too though.
Apart from the contrived connection to Uncle Ben's death, Sandman was spot on. The character evolved into a bad luck thief with a heart. He even went full good guy and joined the goodies working for Silver Sable, and even fighting with The Avengers.
I remember the only reason he rejoined the Sinister Six was because Doc Ock blackmailed him into it;
It's weird that Raimi couldn't get into Venom since he seems really into sympathetic-or-at-least-understandable villains and Venom can certainly provide that, IMO a lot more easily and naturally than the Sandman does.
A loser who blames his loserness on someone else that had no part in his bad luck. Venom is one of the most unsympathetic villains ever. Raimi may not have been a Venom fan, and who could blame him, but he at least gave Brock a valid reason to hate Peter, because in SM-3 Peter does directly cause Eddie's downfall.
Which I personally think was leaps and bounds better than what the comics did with the character. The movie actually improved Venom over the comic book version. In the comics Eddie Brock hates Spider-Man because Eddie published a news story about Sin Eater's identity that turned out to be false when Spidey caught the real Sin Eater. He got fired and his life went to crap, and he blames Spidey for that. All Spidey did was catch a serial killer. He didn't even know Eddie from Adam. They never met. Spidey was not an obstacle to Eddie writing a good honest news story.
In SM-3 Raimi made an actual connection between Peter and Eddie, and he gave him real reasons to hate him. Peter exposed Eddie's fraud, roughed him up and humiliated him, and dated the girl Eddie was infatuated with.
Infinitely better than comic book Venom. Comic book Venom has one of the stupidest motives in comic book history. He's also one of the most overrated characters ever. Why is he considered a top Spidey villain, who some rank beside Goblin and Ock? Because he has similar powers to Spidey? Whoop dee doo. He know Spidey's identity? Big deal. What's he ever done with that? Stalk him? Scare MJ once? Pathetic and boring.
What did Goblin do when he learned Spidey's identity? Killed Gwen. What did Ock do when he found out Spidey's identity? Killed Peter himself and stole his body. That's not even counting all the other major stuff these guys did like Captain Stacy's death, hospitalizing Aunt May, making Peter and MJ lose their baby etc. Venom has never done anything that hard hitting.
Venom is a classic example of style over substance. A character who rose to popularity because of cool look and powers. Scratch that surface and there's not much underneath. I always thought it was ridiculous that he got ranked along side Goblin and Ock. They earned their A-list status. Venom didn't.