First movie has a college age Peter become Spider-Man, while his teacher becomes The Lizard

Second movie has him living with MJ working at the Bugle, struggling to adult and JJJ funds Scorpion to compete with Spidey, under the assumption that he's a charleton anyway, but Scorp goes nutso. Scorpion is redesigned to be red or brown or something instead of green

Third movie has Green Goblin, Norman and Harry have been built up in the previous movies, culminating in the Goblin now. Eddie Brock is introduced as a minor antagonist working at the Bugle. End of movie teases the symbiote

Fourth movie is all about Venom, Peter is stalked and tormented, MJ is horrified, in the end Peter saves Eddie's wife and he doesn't kill Peter

Spinoff R rated movie, Venom Lethal Protector. Street level crook slayings, Life Foundation fuckery, they steal Venoms baby, it escapes captivity and bonds to serial killer Cletus by pure bad luck

Final movie, Spider-Man and Venom vs Carnage. Side characters Shriek and Black Cat join the fight. It's over the top, too long, and action packed, series over

Personally idk why he gets a rep for looking dumb. Sure, his OF design is bad, but it's easily fixed

Electro (no explanation needed), Ock (Elton John), Mysterio (Literally a bowl on his head), Kraven (Village People reject), Rhino (A kids Halloween costume), all look way dumber than modernized Scorpion looks