Help! Sugesstions please...

I am in desperate need of a camera, but on a relatively small budget so an SLR is out. Someone recommend the Cannon G10 to me, but I am open to any feedback. I am looking for a camera that will take really clear pictures, maybe sharp enough that I could photograph my work without hiring someone. (I know it will never be the same but I've got to start somewhere). Anyone have a camera in the under $500 range that they love and takes great pictures?

I really appreciate the help and input!!!!!