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)
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)
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.
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.
Continuity mistake: When Peter is looking through his father's file in his bedroom, Uncle Ben comes in and starts playing with a Rubik's cube from Peter's desk. When he sets it down, the top and middle row are red and the bottom row is white. Shortly afterwards, when Peter is researching Doctor Connors on his computer, the top and middle rows are suddenly white and the bottom row is red (not fully solved, as another listed mistake claims).
Continuity mistake: During the scene where Uncle Ben is talking to Peter in Peter's bedroom, on his desk there is a solved Rubik's cube. Uncle Ben picks it up, and twists it slightly. It then suddenly appears on the opposite side of the desk next to Peter, too far away for Ben to have placed it there, fully solved again.
Continuity mistake: After Peter grabs Flash against the lockers, who says he's sorry for Ben's death, Peter walks to Gwen. The passers-by are not continuous between shots.
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