This is a very personal choice, but here are some of my experiences


Firstly, remember that it is not about the camera, it is about the lighting.  Do not have a window or light behind you or the white-balance on the camera will go nuts and you will look like you are a part of the Witness Protection Program


Any USB camera should be OK, here are a few of my experiences (very personal experiences so be sure you find the right camera for you)


Logitech Orbit AF (~$130)
Best overall lens, focus, motion-tracking (motor driven), desktop only (no clamp) and PC only
http://www.logitech.com/en-us/webcam-communications/webcams/devices/3480


Microsoft LifeCam Cinema (~$80)
Excellent lens, best auto-focus, great stand/clamp, PC only
http://www.microsoft.com/hardware/digitalcommunication/ProductDetails.aspx?pid=008


Eyeball 2.0 (~$60)
Great for the Mac, not as good for the PC (seemingly poor light management), excellent microphone (easy to see why if you look at the images), good stand/clamp and stores to travel very well.  Note that is you use this on the Mac with a Virtual Machine, be sure to avoid using the Mac iSight and this camera as the use of both cameras wrecks the frame rate on the Mac for some reason, stopping the iSight fixes this.  The reason this might be an issue for Connect is that you need to start the iSight in the meeting and then this camera as a second camera in order for it to be recognized by Connect, so this kindof makes the problem for you.  Just stop the iSight and it should be good to go).  See also notes below on ‘Mac users and Connect’
http://www.bluemic.com/eyeball/

IPEVO Point 2 View USB (~$70)
This is an amazing camera for close-up work on a device or a smaller product for example.  The stand is excellent with many placement options for the camera and the ability to lock the auto-focus (a button on the camera body) makes it very clean and easy to use without the constant unnecessary refocus issues you often see.  Maybe the best overall option I use right now…not a very wide-angle lens though so that is not idea for larger (boardroom) sessions.
Note that is you use this on the Mac with a Virtual Machine, be sure to avoid using the Mac iSight and this camera as the use of both cameras wrecks the frame rate on the Mac for some reason, stopping the iSight fixes this.  The reason this might be an issue for Connect is that you need to start the iSight in the meeting and then this camera as a second camera in order for it to be recognized by Connect, so this kindof makes the problem for you.  Just stop the iSight and it should be good to go.  See also notes below on ‘Mac users and Connect’

Mac built-in iSight Cameras for Laptop and Cinema Display ($N/A)
These are surprisingly good with Connect in all lighting situations, the huge irritant for me it typically that the camera in the laptop screen looks to be designed for Hobbits and if you want the camera to have you on-frame the screen is invariably at a poor angle for viewing the text.  Not an issue with the Cinema Display as much it seems

Note for Adobe Presenter users – if you happen to use Adobe Presenter in a virtual environment on your Mac (I use Parallels mostly) then using the built-in iSight cameras seems to be a non-starter.  It seems that the drivers take way too long to initiate the camera and the video is very out of sync with the audio.  Using another (third-party) camera seems to be a far better option

Note for Mac users overall with Connect and Cameras – Most people should be aware of this, but oddly the Mac does not seems to play nicely with Adobe Cameras and recognizing them easily or consistently.  If you do not see your camera when you start up the Camera in Connect, go to ‘Settings’ (right-click) and select the next camera in the list of cameras, the default USB camera is often not the iSight at all (it really should be).  Also, if you want to use a third-party camera it will often not appear in the list of available cameras, so you need to start a second Connect Meeting Room and select the camera from the second meeting…they third-party cameras do not seem to be available until you activate the default (built-in) camera.  there is a way to disable the built-in iSight camera on a Mac, but it involved modifying Mac System Files and as a defence against being blamed for completely trashing your computer I will let you find that out for yourselves with a Google search and a conversation with your IT folks!

Any USB or Firewire Camera should be fine with Connect and much of the decision is based upon the diminishing returns around cost and (oddly) the quality of the camera stand or mount and it’s suitability to your environment.