I have not looked at the links DDonSS3 posted, but I will share my experience...
I am going mediaschool, so we do get alot of photography lessons (Even though I'm more into video and film) and one thing you should know, megapixels.. If you are going to publish your photo on a huge poster, such that cover a wall or standing next to the road, or if you have an sbolute urge to zoom into your picture from your PC, only then is it need for a high megapixel rating.
Go for macro-focus. If you check more specific details about a camera, it will for example say "Macro - 2,3" that means the closest you can go to an object, is 2,3cm. May be inches overseas. They usually supply if it is mm, cm, m, inches, foot, etc.. The lower the number, the better the modelcamera!
And I do agree, get one with the old fashioned viewfinder. Your camera will last better, and you will actually take better pictures aswell. Always use the viewfinder (Exept when on a tripod) for the simple fact you do support the camera to your face that way. Which do simply equal to a way more stable camera. Which again, equals to better photos.
Do neither go for these extremely tiny cameras either. Like, debit-card sized (Overexagerating, I know! lol) but rather for a good chunk of camera. This will result in a larger cencor inside, and better photos.
If you also do like to go amateur photographing, you may aswell pick up an SLR camera, with a macro-lens for modelling. These are, indeed, way more expensive, but if you are more serious into photographing, this is the way to go. But if it is only for modeling, turn around! quick!
A lens of a good brand and good quality can quickly get over 1000, even 2000 US Dollars.. But a decent lens is around/under 1000$
If you go the SLR way, and then the cheaper models (Canon EOS 400, 450, Nikon D40, D60, etc.) that are around and under a 1000$, do not think that one brand is better than another. They are all equally good, be it a Canon, Nikon, Olympus, Sony and whatnot. You should go to a store near you where they sell these, and simply ask if you could try them, atleast hold them. Then go for the one which your hand fits the best, and the one with the buttons suiting you.
When it comes to my camera, I use a Panasonic NV-GS 230. It got 2.3 megapixels and 3CCD. That is one core on the colour processor for the three main colours, so my camera is top-notch on colours.
The camera is, indeed, a video digital camera. But I can slap in a memory card and take photos on it aswell. And the focus of my camera is just loveable. I can go very, very close to an object and still get a sharp photo, and that is without the macro...
Here for example, is a photo of two 1/72 Jerrycans from an Italeri kit. In focus pretty good, good quality, 2.3 megapixels, no macro. I can even go closer. And turning on the macro, I can go superclose:
And a photo of my camera:
Hope my talking helps!
-Lasse