For really thorough reviews with comparative photos shot with the camera and very detailed specs of the cameras I recommend looking at "Steves Digicams" reviews- link below.
http://www.steves-digicams.com/camera-reviews/
I have tried a number of cameras and from my experience and from recommendation of two professional photographers I know well, I agree with Paul Miller for you to look at the Canon line. They have a better color rendition than Nikon and have a good range of function and prices. Almost all of the SLR variety will allow manual focusing-but you need to disengage the auto focus. Manual zoom is a given. The Canons' have 10 and 12 megapixel cameras that should fit in your budget of below $1,000.00us The TI1 Paul mentioned earlier is a 15 megapixel with the features you are looking for including the budget
( with some shopping) live action screen and it will shoot videos. I have my sights set on one of these to replace my old Canon EOS Rebel
Good luck and let us know what you come up with.







