HD cameras perform very poorly in low lighting....very poorly. I would only recommend shooting HD at night if you have a good lighting system. Sony cameras have always performed the best in low light situations, but the lighting problem with HD is relatively global. There are no good HD cameras under $1000. I doubt there are bad ones in this price range.
Best Regards,
Corey