canon s100/300 are nice, but high in price.
don't get the d490, get the d510 instead (if you go this route), same thing w/ USB basically
And like everyone else said, ignore anything that says "digital zoom."
I personally want the new Minolta one.. heh.. CF and AA batteries, the combo i'm looking for. ahh.. 7x optical (ok, 10x would be nice, but canon's is too expensive and proprietary battery, and the olympus uses SM

).