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.
Continuity mistake: When the one of the cups of coffee falls off the table Peter catches it. After that, Peter takes the other cup from the desk to give Dr. Connors. In the first shot Peter carries the cup from the upper part, next shot the cup is on his palm.
Audio problem: As Dr. Ratha says to Dr. Connors, "The clock is ticking, Dr. Connors", his lips do not match what he says and are still moving shortly after he finishes speaking.
Continuity mistake: When Peter asks Flash to stop bullying the other student in the outdoor eating area, right before Flash punches Peter, Peter is carrying his camera on a strap on his right shoulder. As the shot changes to Flash punching Peter, the camera strap disappears before Peter even gets hit and falls to the ground. Later we find Peter's camera smashed on the ground next to his backpack and skateboard.
Continuity mistake: In the scene at school when Gwen invites Peter to have dinner at her house, Peter initially removes both earphones when Gwen talks to him, but when Gwen asks about the bruise in Peter's eye and the camera angle shifts, the right earphone is still in his ear.
Continuity mistake: Launched by the Lizard, Peter slides on his back through the lab and a small stone lays by his head. A frame later, when the Lizard steps on his arm, the stone is gone.
Continuity mistake: When the Lizard is cornered by the cops at the deli, note the column behind him: First it has 6 bullet holes, then after the shooting it's got 30, then in a brief close-up it's back to 6 holes.
Continuity mistake: When Peter, in his beta-suit, traps the thief, a woman behind, holding a flower bouquet, disappears in the final shot.
Continuity mistake: At the deli, when the cops have shot down the Lizard, watch the back part of the robe, where the bag strap is: It swaps from a big open hole, to being split in two big sizes, to split in a big and a small size hole; all in a matter of frames, no sense whatsoever.
Continuity mistake: In the scene when Peter Parker goes back to his Aunt & Uncles house after his first Spidey-training session, he raids the fridge & freezer. When confronted by his Aunt & Uncle, the freezer door is slowly swinging open, but in the next shot, the freezer door next to his Aunt & Uncle is closed.
Continuity mistake: In the subway Peter smacks a guy's head against an iron bar, and he falls backwards. A shot later he is standing straight.
Continuity mistake: In the subway after Peter wakes up and gets stuck on the ceiling his hairstyle changes three times in the following shots.
Continuity mistake: While Captain Stacy is dying Spidey is right next to him with his left arm on him, but in the next shot he is now 1 or 2 feet away.
Continuity mistake: While Peter is sleeping in the subway he has something on his head as a pillow which suddenly disappears.
Continuity mistake: While uncle Ben and Peter talks with Gwen in the school hall, her hands and the folder change positions between shots.
Continuity mistake: After the lizard attacks Spidey in the school he left his coat in the bathroom, but when he gets to the sewer he has it back again.
Continuity mistake: Before the lizard assaults Gwen in the lab, she has her hands on the device with nothing else, but suddenly has the spray bottle and the lighter.
Continuity mistake: When Spider-Man is launched against the library, when he lies on the floor the type of books next to him change 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