Well whilst this post is alive will add a little to it.
At the current time I have a Nikon D2X D-SLR and a D100 D-SLR. One for the good stuff, one for taking snowboarding etc so I don't mind it getting knocked about a bit, and also have a little pocket 10MP Samsung.
I am lucky in that I have had the opportunity to try/test lots of cameras and would offer the following advice.
1) You get what you pay for.
2) If you want a D-SLR then go with Nikon, Canon, Olympus, Pentax, there are other good cameras out there but these have proved to be robust, and have access to a much greater range of Lenses etc and a far more buoyant 2nd hand market. Add Fuji to the list as many of their D-SLRs use the standard Nikon F-mount. This mount is compatible with every camera and lense manufactured since 1942 by Nikon, many other companies change mounts etc every few years.
3) Only an SLR will give a truly instant shutter release without the processing pause before the picture takes on most compact cameras.
4) If buying a compact look at the Optical zoom figure, higher the better, Digital zoom is not the same and image will degrade the more you use the digital zoom.
5) IMO avoid makes like Sony, who frequently change connector types, fittings, software compatibility, although they now use Carl Zeiss lenses, this is really only a marketing ploy as these lenses are still only on par with pentax, canon etc it doesnt offset the built in low shelf life.
Ok thats a few thoughts not looking to start a row over cameras, however if anyone wants any advice on purchase or photo taking feel free to PM me and I shall endeavour to help.
Heres a shot taken with the D2X fitted with a Nikon wide angle VR lens. This is not the ideal set up, lens is pretty unsuitable, no macro and taken with only 40w of light on a very high ISO setting, editing wise white/black was balanced and size was edited, no other editing, will post some nicer shots when my macro lens and flash unit comes back from loan.