Dave,
I use a Canon Digital rebel with hacked frmware (just a bit of improvement to this old dog )
It is just great for what I am doing. Usually i use a AV settings - apperture set toat least 16 and than I use a wired shutter release while camera is mounted on a tripod. This way I can get pretty good settings for depth with a natural light instead of flash - what flattes the picture really badly.
Some long time ago I decided to invest into best camera on the market - and it is still doing its job very well :)
Now you can get the same functionalityfor about $350. I like those gadgets :)
Greg