have not read this entire thread... hope this has not been posted
first off if one has the $$$ budget, then by all means go for the high $$$ option of a super nice DSLR by Nikon or Cannon. but if your budget is less, like say $50... here's some great options that produces pictures for web, as good or equal to it's high $$ brethren.
assuming one is shooting for the web, say goal is super clear chainsaw pic's to post on AS.
1. forget about megapixel ... for web shots your resolution doesn't need to exceed what your screen is capable of displaying. VGA is plenty of resolution for most shots.
2. zero in on getting the highest quality lens you can afford. Leica, Zeiss, Nikon, Cannon, Sony all make prime lens.
3. friendly user interface (UI) makes all the difference between a camera getting used vs sitting in the drawer. IMHO Sony makes one of the easiest to use UI of any camera.
4. learn how to use photobucket (free) and Firefox with photobucket uploader add-on (free)
a camera that meets above criteria is an ancient Sony Cybershot DSC-P73 with 4.1 meg.
keep an eye out on craigslist about $30, some Sony Cybershots (DSC-P200 7.2 meg) comes with Zeiss lens and pop up on CL for $75 or less.
Pansonic Lumix came with the fabulous Leica lens. DMC FZ20 can be found for low $$$
naturally your topic means a lot too... here's very low hours Stihl 07S with paint still intact on drum. both pic's were taken at 600x800 VGA resolution with a cheap ($30) Sony DSC P-73