While I certainly value my 3 tripods, I don't use them very often on quick gun pics I post here. I've had excellent results with a couple point n shoot digitals. One is a few year old Konica Minolta Z2 and the other is a Pentax WP pocket sized waterproof camera. The Z2 is probably the better of the two in terms of quality and ease of use. I also have a Nikon D50 with a selection of lenses including a 60mm MicroNikkor.
No matter the camera you choose, and there are many good ones for your task, lighting will play the biggest factor in your pics. You can choose to use studio type lighting (whether makeshift or pro stuff) or use a TTL remote capable flash using bounce and other 'tricks'.
