These are not gun pictures but they will give you an idea of what can be done. The camera on most of these were a Nikon D90 using various lenses and in some cases fill-in flash which is the one built into the camera and I also use a Nikon Speedlight SB 700 which can be used by itself or set elsewhere can be triggered by the camera's flash.
Nikon D3000 with Vivitar Macro 100 lens. A Very cheap lens, sounds like something is loose when it focuses but great pictures,

D90 with Vivitar Macro 100 and Nikon Speedlight SB700

D90 with fixed 105mm Nikon taken at sunrise.

No tripod used on any photos, but not a bad thing to use. The heavier the better. For set-up shots I have an overhead 4x8 aluminum faced insulation board mounted to ceiling joints and set the camera on a tripod and bounce the flash off the ceiling panel.
One of the better buys from Nikon is the Nikon 35mm 1.8. a great lens for a fraction over $100. Takes great close-ups and is a fast lens for low light conditions.
Picture is just cropped.

This is what I use and like, there are plenty of other cameras and they don't have to be an SLR. I have used the other non SLR's but find them lacking in most cases.
Another thing to taking good pictures is to have Photoshop or Illustrator as these can make a bad picture good.
Never believe what you see on a magazine cover as being straight from the camera.