I'm inclined to agree with the Canon Power shot sd400 for an affordable camera with supurb qualities. After seeing Kristykins' pics on this board with her sd300! I'm about to make the same move for the sd4oo or sd450. :p
I use a Kodak DX4530. But what I have discovered is that it really isn't the make of your camera but the megapixels it takes. They go from 3 to 8. The higher the megapixel the better the finished product, irregardless of make or model.
The cam I have is a 8 and I couldn't ask for a better pic.