At the low end, there are the Canon HV30 and Sony HDR-HC9. Because of their price, you would have budget left over for mics, tripod, lights, maybe some Steadi-cam gear. Both do DV and HDV (and use miniDV tape). They are very clearly consumer cams - but you could get more than one and multi-camera shots are fun to edit. They are both single CMOS.
Then there's the Canon GL2 and Sony DCR-VX2200 - both are prosumer-grade - bigger lenses than the last two, but they shoot standard definition only. They are both 3CCD cams.
Then comes the Sony HVR-HD1000U. This is an entry-level shoulder-mount cam that looks more pro, but the feature set is not that robust (more like the HDR-HC9). It shoots DV and HDV. Single CMOS.
All the camcorders to this point - on this post - use 1/8" (3.5mm) audio in jacks. If you want to use pro XLR connectors, you need an XLR adapter like those from juicedLink or BeachTek.
Then comes the Sony HVR-A1U. Nice small, DV/HDV cam with XLR audio jacks on top. Has some other cool features. Single CMOS.
Then comes the standard def Panasonic DVX100B - also with XLR audio connections. 3CCD.
There are others - but this is a decent starting place.
MiniDV tape can capture/store DV and HDV. In this price range, there is no HDV with 3CCD or 3 CMOS... There are standard def with 3CCD.
I think the least expensive HDV with 3CCD is the HDR-FX1 or HDR-FX1000... more than you want to spend.