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.
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