Hardware Extreme has a large roundup of current 5 megapixels cameras ranging from SLR like cameras to the more compact ones.
Digital cameras offer significant advantages when compared to film-based cameras. Digital cameras are also becoming increasingly popular. This factors including the dramatic expansion of the Web, our insatiable appetites for visual images, the accession of affordable printers capable of producing photo-realistic results and falling prices, will set the digital camera on the path of becoming a standard accessory for the home or business computer. In addition, the quality of digital imaging technology is rapidly approaching the conventional film-based cameras. With digital cameras, you can "save" the ones you like and "delete" the ones that you don't.

Source: http://hwextreme.com/reviews/misc/showcase12/