The Kodak 3900 came out in 2001 and is a typical point-and-shoot camera.
The flash output of this camera is 10.4 feet.
When you talk of low light, that takes in flash and non flash photography.
Flash photography requires a stong flash, which is not typical in most digital cameras.
The long lens cameras (10X) have the strongest flash.
The more expensive cameras have a hot shoe that lets you attach an outboard flash unit. These flash units can easily cover 30 to 50 feet.
Non-flash in low light can be done with just about any digital camera that has manual controls. The important manual controls to look for are:
Shutter priority
Aperture priority
Program mode
Manual mode
Non-flash action shooting in low light requires a fast lens and a camera with lots of noise free ISO settings. This takes you into the DSLR (digital single lens reflex) cameras, that start about $1,000.
................................
For a low priced general purpose camera with an average flash coverage (13 feet), I would suggest the Kodak DX7440.
For a long lens camera I would suggest the Konica Minolta Z5. It has 26 foot flash coverage, and a 12X lens with image stabilization.
A more expensive camera would be the Panasonic FZ20.
...
..
.