I use a 3mp Sony P32, its a cheap camera now, no tripod. I think the key to a good photo is good light, I always take gun photos outside. Make sure the sun is behind you but dont cast a shadow over your subject. Its also easy to lose your weapon in the background, so either make sure the background isnt too busy, or be far enough away fromt hebackground that it'll be out of focus and look fuzzy.
I tend to get very close to photo detail which is fine so long as its light enough.