Continuity mistake: When Peter is getting the tour at the OSCORP office and talking to Gwen, initially there is a yellow robot behind Peter; in a later shot it has changed to a tank.
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 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: 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 uncle Ben and Peter talks with Gwen in the school hall, her hands and the folder change positions between shots.
Continuity mistake: While Peter is sleeping in the subway he has something on his head as a pillow which suddenly disappears.
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.
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