Well... I own the 40mm 2.8, 85mm 3.5 and 105mm 2.8G (owned the Tamron 90mm).... for the 3200 it'll all come down to what you plan on shooting for macro, and what your budget is like.
The 40mm 2.8G for DX is a good choice if you are shooting things like food photography and want to get up close to any object. This gives you a FOV of 60mm on an FX body. This is also a good choice for short tele portraits.
The 85mm 3.5G VR for DX gives you a FOV similar to the 105mm, with great DOF and puts you in a place if you plan on shooting shots ranging from close up wildlife like bugs without being too close. Helps with poisonous creatures you would not generally get close to.
The 105mm 2.8G VR would be self explanatory. This is the choice of many as it will work on DX and FX bodies. However budget aside, there are other options available which are on either end of the scale. VR helps with hand held photography and this doubles as a nice portrait lens with good range.
These are my go to lens for getting that particular shot, with any said camera body I use. If you are planning on sticking with DX bodies the 40 and 85 are both good choices and neither will break the bank.
You will however want to consider options based on your style of shooting and budget, as any true macro lenses will not be a lens you will use everyday. So depending on how your budget will allow for the lens will probably be a bigger hurdle. If possible try the lenses at your local camera store and see if any of them will work for you.