I have a nice Olympus Stylus 4.0 megapixel. I bought it because it was small (fits in my purse), I had an Olympus 35mm before which I loved, this one is a "sport model" supposedly water resistant, and my price range at the time was a couple hundred. I really like it, but I can't get excellent photos of my tank inhabitants - and that seems to be what I want to photograph most.
My fiance did his research on Consumer Reports. He has a Kodak Easy Share DX7630. It is 6.1 megapixels, and it takes very nice tank shots. For a comparison, you can look at my thread "ID help please". The first photo (green background) I took with my camera. The second photo, I took with Len's Kodak. Each was taken through a 10x magnifying lens. [That was something I learned in my past line of work, when I used to take a lot of photos through a microscope & sometimes had to improvise 'cause I didn't always have the proper equipment.]
The only downside I've found with the Kodak is that there is no Mac compatible software, so I can't download his pics to my computer. He has to download them to his Dell, then e-mail them to me.