I have the same thing going on.
- I have an iPhone 4S
- A Windows 7 computer with iTunes updated to 10.7 before the download
- I downloaded iOS 6 and at the end my iPhone reset and is now stuck on the connect to "iTunes" screen
- The device doesn't show in iTunes and I've gone through the whole iTunes Support "iOS: Device not recognized in iTunes for Windows" guide 1-6. It shows up perfectly in the Device Manager.
- The interesting thing is that in "Computer" it doesn't show "iPhone" like normal, but "Photo Stream" the new iCloud service with iOS 6.
- Clicking on "Photo Stream" brings up the iCloud program on my computer and asked me to log in and set up iCloud (which in my case I never setup before)
- Once set up "computer" still only shows "Photo Stream", which then goes to the "My Photo Stream" folder, which is empty
- I have reset both the computer and iPhone a few times and the phone is still stuck on the connect to iTunes screen and iTunes won't recognize the iPhone.