I can only tell you about my experience.
About 7 years ago, I bought two of the "low light" NiteWatch cameras from X10, with the intent to use one as a baby-cam (I didn't have a specific purpose for the second one at the time, but it was a "buy one, get one free" deal).
It worked great during the day, but it was completely useless at night.
We had a lamp in the room, which had a 25-watt bulb in it. I used a Lamp Module to dim the lamp down to around 35%, so there was enough light to see if we had to change a diaper in the middle of the night, but not enough light to disturb the baby's sleep. It works great as a night light, and we didn't have to turn on the overhead light with the three 60-watt bulbs in the middle of the night.
With the "low light" camera, that wasn't anywhere near enough light, even though I could see just fine with even less light in the room. I played around with increasing the brightness of the lamp, and found that I had to go almost all the way up to 100% before I could see anything useful in the picture. Since the 25 watt bulb at nearly 100% was way too bright, I wasn't able to use the X10 wireless camera for that application. The other problem I had was that rotating the camera on the Ninja base caused the antenna to move (since it is attached to the camera and not the base), and the signal would get much weaker.
I found a wired "night vision" camera at Home Depot for about $50. It was a pain to fish the wires down to the basement, but it has worked flawlessly for years now (the baby is no longer a baby, but has younger siblings ;-). The camera has 6 IR LEDs around the lens, and works even in complete darkness, where I can't see a thing with the naked eye.
At the time, they also had a 2 or 4 camera wireless system at Home Depot, which also had night vision capabilities. I don't remember who makes it, or if they still have the same ones there, but it might be worth looking into.