I use a Nikon D300, an I currently own a 50mm f/1.4, a 80-200 AF-D f/2.8, a couple kit zooms, and a 105mm f/2.8mm VR micro; Good for photographing the hair on a fly's rear.
If i was shooting a non moving subject, even in low lighting, I would simply use a tripod, a remote release, and mirror...