Go HD. You won't regret it.
Cams to check out...
HMC150, XHA1, and if you're buying used you could look at the HVX200. All of these are great filmmaking cameras. I'd suggest you stray away from the sony FX1000, Fx1, or FX7 just because they have limited audio capability.
For standard def, the only camera that's really worth the price is the DVX100B. The XL2 is great but it's just too expensive.