What gives a camera its picture quality?
It is mostly the skill of the photographer that produces high quality pictures. The lens and camera are very important, but the ability to set the scene, adjust the cameras settings, and hold the camera very still or use a tripod with auto or remote shutter actuation when required is what gets the great pictures. Mega pixel resolution is about potential photo size, not picture quality.

In new cameras, look for a viewfinder (LCD invisible in bright sun), optical image stabilizer, and check battery prices. High mega pixel settings take longer to process and may not be needed unless required for very large pictures. Maximum print size for a 3 mega pixel setting is 8 x 10 inches. Click links below for more details.
http://www.kodak.com/eknec/PageQuerier.jhtml?pq-path=398&pq-locale=en_US&_requestid=2039 ...
http://www.kenrockwell.com/tech/mpmyth.htm ...

The Canon A590IS is a slightly older model that is available everywhere at great sale prices. Think it is a great camera and a best buy. It has auto focus, a viewfinder, optical image stabilization, and uses rechargeable NiMH batteries.
http://www.imaging-resource.com/PRODS/A590IS/A590ISA.HTM ...
http://bountii.com/deal-1523871-canon-powershot-8-0-megapixel.html ...

For expanded wide angle or telephoto capabilities, the A590 IS is compatible with Canon's accessory lens adapters: A small button next to the lens bezel is actually a latch; press it and you can remove the bezel ring, exposing a bayonet mount for accessory lenses. Canon offers the WC-DC52 0.7x wide-angle lens, the TC-DC52A telephoto lens, the 250D 52mm closeup lens separately, along with the LA-DC52G adapter to mount them on the camera. (Note that the wide, tele, and macro lenses all need the LA-DC52G adapter to mount them to the camera. The lenses won't work by themselves.)

There is no one particular place to get great buys, but you may see something above that really helps you find the best buy. Click on the second link in the information above for an example then search for your camera of choice at the upper left. Camera prices at this link change often.

There are so many cameras out there it is difficult to say which is best. The second source link will be very helpful as it list most of the cameras out there with prices. The following information should help you know what to look for in a camera.

CAUTION Do not overcharge! Batteries can be damaged. Use an automatic two or more hour Energizer Compact smart charger with temperature monitor, trickle charge technology, and safety timer ($9.76) at Walmart. Use pre-charged 2000mAh Duracell ($12.97) or RayOVac ($5.97) batteries (hold charge one year) and a full cycle charge. To preserve battery charge, use the viewfinder.

CAUTION To prevent memory card corruption, keep batteries charged and don't delete. Wait for lights to stop flashing then turn camera off before removing memory. For card readers, double click Safely Remove Hardware. Select, then click Stop and OK.

Lots of great camera tips in this link.
http://www.danscamera.com/Learning/going_digital/#resolution ...

This could be the best slim line camera with a viewfinder and ... It's PINK, but it uses a $49.50 Series G Rechargeable 960mAh lithium-ion battery.
http://shopping.yahoo.com/p:Sony%20Cyber-shot%20DSC-W150%2FR%20Digital%20Camera:1995337750;_ylc=X3oDMTB0bjZzaWNuBF9TAzk2NjMyOTA3BHNlYwNmZWVkBHNsawNlbGVj ...
http://www.digitalcamerareview.com/default.asp?newsID=3462&review=sony+cybershot+w150 ...

My camera has 5.2 mega pixel, but I use 3 most of the time because it gives great results, is faster, and takes less memory. Also, it only has a 3 x optical zoom and 7 x digital zoom. I never use the digital zoom because making pictures larger works better on the computer. This is an old camera, but everyone is impressed with the quality pictures it takes ... like magic.

Check with the Geeks in several stores and compare prices. Once you select a camera, read all about it in the owner's manual. You can view owners manuals at this link, but will need to Login. http://www.retrevo.com/s/digital+camera ...

The source links show most of the cameras out there with prices and make digital cameras work better with help on cleaning camera and battery electrical contacts.