a lot of point and shoot cameras are within your budget and almost all of them can give good results (brand doesnt matter).
nikon d80 (a digital single lens reflex camera)can give you excellent results as well but only if you know how to use it. d80 and the likes are expensive and require frequent adjustments to get excellent results. It is use mainly by creative photographers only.