i have the sanyo scp 5300 - it's pretty decent. i like the fact that it has a flash and a digital zoom, although the zoom can only be used while taking high resolution pictures (there are three resolutions - low, medium, and high). like most phones, it doesn't have too much storage space. if i remember correctly, i can store something like 10 or 15 high res photos and a few lower res, as well.

just don't get a phone with an external (detachable) camera - my boyfriend bought a camera for his sony ericcson phone, and it is really awful.