The Dlink (Digilink) Camera Model - SSC 350FSV gives great pictures.
It has a flash option too, but one seldom needs to use this flash as even in flourescent light the output is quite good.
Operated on two AAA cells, this can be taken to any destination and shoot upto 120 pictures. One can shoot pic of size 640x480. One can even shoot pictures of flowers in the macro mode and make good wallpapers. I shot quite a few with good results. Infact I shot pictures all of my colleages and implemented in our Payroll software with great results.
The features of this small camera come in handy.
One can even shoot a small video footage(Though very bumpy)
The Camera can also be used as a webcam and its compact size is an added plus.
I ahve been using the Camera for quite some time and I love the results.