I have the Kodak Play Sport that I just picked up dirt cheap at Staples. It's water proof to 3 metres which is why I wanted it. Good side- it's compact (actually smaller than my cell phone) and has a nice crisp clear full 1080P HD video when the lighting is good. Down side-like every camera it gets grainy in low light. Still pictures are only 3 megapixel and the zoom on it is only a 4x zoom.
Since I normally use the HD video that is built in to my Canon Rebel anyway, I wanted a camcorder that I could take camping and not worry about the rain etc.
A search for compare HD camcorders can help you narrow things down as everyone is going to want something different out of their equipment.
http://camcorders.toptenreviews.com/hdv/ has a few reviews, but if you have a local store like Henry's or Black's (ok I admit these might be specifically Canadian but you can use the search functions on the websites) then once you have narrowed down your choices, go into the store and ask questions. A store like Henry's will let you play with the equipment in store too. You don't have to tell them it's for 'adult work' just that you will be using it in indoor low lighting or outdoor bright sun or whatever the conditions will be when you use it mostly.