Any Recommendations For Canon Digital Slr Camera & Macrolens

Tamron 90mm macro Sp Di for macro has the same qualities as the 100mm canon lens just hunts more so use it on manual focus.
Re the Camera try for a 24 meg which here is a 750D.
heres my set up with the rebel T3 12 meg and 90mm tamron

https://goccf.com/t/194870

and this is my smallest coin 7mm across taken with this setup on a Mac computer

I have a T3i and the 100mm Canon macro lens which is a WONDERFUL lens.

You're probably not going to be happy taking pics of DDOs, RPMs, etc with a standard Macro lens. Most of them only go up to 1:1 magnification. If you use a newer camera like the T6s or T6i, the higher MP count will give you the ability to zoom in on details fairly well, but the quality won't be a whole lot better than the USB camera. You can add a teleconverter to increase the magnification, and this will help. Here are some numbers:

Canon T6x: 6000x4000 pixels (24MP)
Desired magnification: 5x (this is the money shot on a Lincoln Cent, ie full date and mintmark fills the APS-C sensor)
Set magnification to 1:1. At f4, this gives effectively f8, which is diffraction limited on the T6x sensor
A 1200x800 cropped image gives you effectively 5:1 magnification, but the clarity suffers due to the diffraction, AA filter, demosaicing errors, etc.
Add a 2x teleconverter
Lens magnification is still 1:1, but the teleconverter views just the center portion of the image at 2:1 magnification
Effective aperture is now f16, far into diffraction-limited territory
A 2400x1600 cropped image gives you effectively 5:1 magnification
Downsize this image to 1200x800 and you still have the 5:1 magnification image at same size as the crop without teleconverter
Downsizing 2x offsets the diffraction increase caused by the teleconverter
Downsizing 2x also eliminates most of the effects of AA filter and demosaicing algorithms, resulting in a sharper image

Now, this works pretty well for a high MP camera, up to about 5:1 magnification, perfect for the Lincoln Cent money shot, but for documenting mintmarks you need 10:1. You can get there with a crop to 600x400 but the resulting image may be too small.

A lens such as the Canon MPE-65 can give you the range up to 5:1 native, or 10:1 with 2x teleconverter. Or you can do a combination of cropping at a lower magnification as above. Quality of the MPE-65 is very good but working distance is fairly small.

Other option is to go with a microscope objective at 3x, 4x, or 5x. Disadvantage is that the higher quality of the microscope objective vs standard Macro lens will force you to focus stack to get the full surface topography of a coin in critical focus. This is because the microscope objective is used wide open, and thus has small depth of field at the higher magnification, but sharpness is superior to the other methods described above.

I don't know the guy too well... I will ask him again he had told me but when I looked it up was very expensive and forgot.

But then after day or two of thinking about the quality of those images. I am willing too save up.

The varieties where amazing he could focus right in from computer.

For example on the one nickel you could see each part of the QDO on the star on the usb microscope you could see it but looked blurred together.

I am only looking to do variety details and I am still waiting on reply back from him as to what set up he used for the photo-shoot.

Florida...so the key to his setup is the 65mm lens, which is for sure model number MPE65. It's a $1000 lens that is only capable of 1:1 -5:1 magnification. Can't do full-coin photos. But that's OK per what you're trying to do.

You can get the same functionality with the <$400 setup, with slightly higher quality, though you would not buy the main full-coin lens and probably buy one or two additional objectives to cover a wider magnification range. Should still cost <$400. The <$400 setup recommends a Canon XS camera, which has the same computer-based control system as your friend's T3i.

does it have to be Canon? I have a Nikon D3300 and am loving it.

If you want to see what you are doing in Live View on the computer screen Canon is the only one that has the soft ware and can be tethered to the computer.