Updated review:
Previously, I'd said some incorrect things, and now I've completely disassembled the product to figure it all out.
Before, I (incorrectly) said that this thing didn't have LEDs, just 6 plastic domes with a light underneath. That was because, looking into the domes, I could barely see the light, unless it was pointed directly at my eye. Well, that's just how LEDs work, especially bright white ones. Highly concentrated beam at the center. It gave off the illusion of a single light mounted under the bubbles, and the bubbles just focused the light forward. That was my mistake.
This is not a "night vision" camera, unless "night vision" means "can see in the dark, because it has 6 bright LEDs attached to it". The LEDs are all within the visible spectrum of light, and the lens has an IR filter on it, so even if they were IR LEDs... it wouldn't do any good with that IR filter in place. Again, this is NOT an infra-red / night-vision camera.
There's a dial on the cable, to adjust the brightness of the LEDs... however, instead of getting gradually brighter or darker, it's either "off" for 90% of the dial positions, or "on" for the top 10% of the dial. (That is, if it was a volume dial, 1-9 are "off" and 10 is "on, full power"). Maybe mine is just faulty.
The stand is ever-so-slightly sticky on the bottom, to kind-of hold it in place, but the weight of the cable on the back still easily pulls the camera down, so it's constantly falling. I stuck on silly putty on the bottom, and that was the end of that problem.
The stand also unfolds, and as someone says in the comments, the purpose of that is to clip it to a laptop or whatever you feel like clipping it to.
The camera is plug-and-play, installing the drivers automatically. Moments after plugging it in, it was ready to go, at least on windows XP. I'm testing it now on windows 7, and it doesn't seem to be showing up on my computer as "USB video device" as it did with WinXP. After looking for a bit, I found it. Control Panel -> Devices and Printers -> USB 2.0 camera. Looking at the properties...
Manufacturer: Unavailable
Model: USB 2.0 Camera
Model Number: Unavailable
Categories: Webcam
Description: Unavailable.
I think that's about as off-brand as it gets... no company name on the camera, and no company name under the device properties. Oh well.
Back on Windows XP, the button on the top of the camera saved pictures. I don't recall where they were saved, as I'm on Win7 now.
The lens of the camera says "10x digital zoom" which is a lord of hooey. There is no zoom on this thing, whatsoever. The frame of the lens can be rotated, if gripped tightly (I had to use pliers) and all that does is adjust the focus.
All in all, it's not too bad, but it doesn't do all the things it says it's supposed to do.