Spider-Man: Oh, no! You have found my weakness. Small knives!
Peter Parker: We all have secrets: the ones we keep... And the ones that are kept from us.
Gwen Stacy: How did you get up here?
Peter Parker: The fire escape.
Gwen Stacy: That's twenty stories.
Peter Parker: Your doorman's intimidating.
Peter Parker: I've got to stop him, because I created him.
Gwen Stacy: That's not your job...
Peter Parker: Maybe it is.
Peter Parker: Ahem, you know, if you're going to steal cars, don't dress like a car thief.
Car Thief: You a cop?
Peter Parker: You seriously think I'm a cop in a skintight red and blue suit?
Dr. Curt Connors: Do you have any idea what you really are?
George Stacy: Thirty-eight of New York's finest, versus one guy in a unitard.
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