Continuity mistake: When Dr. Ratha is talking to Dr. Connors, Connors says, "I'm at a dead end, it's the decay rate algorithm." In this shot, you can see that his hand is elevated off the desk. In the next shot, it's back down against the desk. (00:21:48)
Continuity mistake: When Peter is told that the thief that killed Uncle Ben has a star tattooed on his left arm, the way the thief steals the money from the cash register is slightly different from the first time we saw him do it. The scene was re-filmed. (00:44:30 - 00:46:40)
Deliberate mistake: When Connors becomes a humongous Lizard, his robe magically grows from a Medium size to an XXL. (01:06:50 - 01:17:45)
Continuity mistake: Inside the school lab, the Lizard walks to Peter on the floor and a stool next to him suddenly appears for him to pick up. (01:35:00)
Continuity mistake: During the scene where Spider-Man is unmasked he splits an assault rifle in half, trips a man, then drops the two pieces on the ground. The scene switches to a long shot and Spider-Man can be seen still holding the two pieces of the weapon in his hands. The pieces are out of his hands in the immediate following shot. (01:44:50)
Revealing mistake: In the lead up to the final scene, prior to the cranes being in alignment, when Spider-Man is jumping between buildings, he falls down to a fire escape, and you can see that the bars or rails on the railing he lands next to are not made out of metal as they easily move as the actor or stuntperson moves next to them. (01:48:42)
Continuity mistake: When Peter falls through the roof and lands in the wrestling ring, the planks on his body suddenly disappear.
Continuity mistake: While fighting against Lizard in the lab, Peter's jacket changes randomly from spotless to covered in dust, to partially covered in dust, back and forth.
Continuity mistake: While fighting against the Lizard in the lab, Peter looks at his backpack. The position of its straps and the debris on the wall change between shots.
Continuity mistake: In the scene where the lizard and Spiderman are fighting in the sewers, the lizard scratches Spider-Man's chest, causing tears down the front of his suit and chest. He actually scratches straight down his chest, but from then on, whenever Spiderman's chest is shown the scratches are diagonally across him.
Continuity mistake: When Peter is paying at the convenience store, the bottle on the counter turns around between shots.
Continuity mistake: In the scene where Peter Parker is fighting on a train he tells the last man standing 'not my board', the last man is black but after hitting Parker and the board breaking the next shot is one of the guys he has already knocked down who is white fighting him after the board breaks.
Continuity mistake: After Peter leaves home and breaks the glass door, Ben places his hand on May's back. When the angle changes it's on her shoulder.
Continuity mistake: During Peter and Lizard's fights by the lockers, watch the folder on the right side behind them. It sometimes faces a 9 o'clock direction, others an 8 o'clock.
Continuity mistake: In the car thief scene, the cop points his gun at Spidey and tells him not to move. Spidey puts his arms in the air with his upper arms relatively horizontal and his forearms straight up. But in the immediate shot following, his upper arms are also straight up.
Continuity mistake: When Lizard launches Peter through a wall into a classroom, books and huge chunks of concrete fly above Peter, but when he lands and slides backwards they're suddenly gone.
Continuity mistake: When Peter leaves his house and May asks Ben to "leave him alone" her position swaps from half a meter away from the wall to right next to it, with one hand leaning on the frame.
Continuity mistake: When Gwen visits Peter at the end of the movie, you can see that the glass door with the house number "36" painted on it has been replaced from when he broke it earlier in the movie, and it looks brand new. Once she leaves and he turns to Aunt May, the numbers have returned to their earlier weathered and peeling state.
Factual error: There is a scene in midtown Manhattan toward the middle of the film outside a NYC subway station, which according to the sign on the subway entrance is at 6th Avenue and 39th Street. There is no such subway station on those streets.
Continuity mistake: When the roof breaks Peter falls feet first facing to the right side. A frame later, he is falling face down facing the left side.
Answer: Connors believes that humans are too weak and flawed, and that if he transforms them all, he'll create a better, smarter and more powerful species. Presumably, given his motivations are to "improve" humanity, he also believes that society itself will also evolve into something "better" (even possibly utopian) once everyone has transformed. As for all the minutiae like what people will eat, hobbies, etc.? I don't think Connors has really thought about that. His obsession is very surface level, and basically starts and ends at "If I turn people into powerful hybrid beings, everything will be better!" Realistically? There'd probably just be a lot of panic and chaos, a lot of people might hurt or kill themselves when they realise they've changed into another species, and society would probably collapse for a while before slowly rebuilding itself over the course of years.
TedStixon