http://www.usa.canon.com/consumer/controller?act=ProductCatIndexAct&fcategoryid=173
Canon has released the "New" line of HD consumer cams already. Great time to buy, and I agree with the other posters...Canon is an excellent choice in this price range.
The HFM-31, HFM-30 and HFM-300 are the "Mid-Range" line: $800, 700, and 680 are the prices...in that order, and in your price range. Also, all of them are solid state shooters; SDHC.
The HFS-21, S-20, and S-200 are the higher end line...$1300 for the 21, 1100-S20, and $1000 for the S-200.
They also have the HFR lineup....HFR-11, HFR-10, and R-100...700, 550, and 500 MSRP in that order. You may find 10% off on the street/web.
It is time to make the switch from tape, IMO. All NLE's are setup for instant Log and Transfer...no more "Real Time" anything! Very durable and affordable for lots of storage. And the Canon picture is excellent from the consumer line. Sony makes some excellent cameras as well...however, I've had issues transferring and conforming footage from a couple of their cameras with FCP. YMMV. I love the picture from Sony, but hate the proprietary nature of their gear.
Great time to buy!
Jer