The Sony TRV-900 is a fair to good low-light performer, about one to one and a half stops less sensitive than the VX-2000. Out of production now, but clean used ones can still be found. Avoid the TRV-950, its replacement, which does not perform as well.
For a very tight budget, the old Sony TR-81 single chip Hi8 handycam was a terrific low light performer. Image quality probably isn't competitive with today's DV camcorders, though.