Most of the cameras in that range are going to be similar in terms of image quality. I'd just go to your local electronics store and see which ones give you the most manual control.
No camera under 1000 is going to have external manual exposure or focus, unless it's in the menu. I have seen that.
All (most) cameras have adapters so tele, macro, or w.a. lenses can be screwed on.
XLR inputs on a sub 1000 camera will be hard too find too...what you'll have to buy is a mini (male, looks like a headphone jack) to xlr (female) adapter...
The Panasonic PVGS150 is 650 retail, but you can find it cheaper probably. 3CCD 2.3 megapixel.
Step down from that and I'd go Canon. A 500 dollar Canon Optura series I've been told are pretty good. They have the Digic processor in them, so the color will be pretty good.