First of all, learn to ignore much of what Ken Rockwell says... He's wrong almost as often as he's right. The difficulty is determining when he's right and when he's wrong. 200mm may be HIS choice of macro lens, but it's more difficult to use, renders a shallower depth of field and is more susceptible to shake blur... Plus, when used on an APS-C crop camera like yours, 200mm is even more difficult to get a steady shot and the Micro Nikkor 200mm doesn't have image stabilization... Not that stabilization helps a great deal at higher magnification. Still, it can be helpful when working at lower magnifications, such as you'll be using for most flowers.
With Ken R., I also sense a bit of snobbery since the Nikkor 200mm is by far their most expensive macro lens (putting aside the PC lenses with macro capabilities). In fact it's one of the most expensive anyone makes. The 200mm, which is one of the few "D" lenses Nikon still makes (i..e, it doesn't have built in focus motor, so requires D7000-series or higher camera body to be able to autofocus), costs around twice what the excellent Micro-Nikkor AF-S 105mm f/2.8 VR does. That 105mm (or 100mm or 90mm) is a better choice. Even 60mm or 70mm might be an alternative if a more compact lens is wanted.
Amaryllis hardly need a macro lens... Even though I used my Canon EF 100mm Macro for this one:
...unless you're shooting tight details within flowers:
Still, a macro lens can be a great deal of fun. And it will work well for more than just macro shots:
And it will give you the option to shoot small details if you wish:
At around $400 or less, one of the "most affordable" macro lenses is the
Tokina AT-X 100mm f/2.8... but in the Nikon version it's a "D" type lens (see above...no built in focusing motor, so it would be manual focus only on D3000-series or D5000-series cameras... able to AF on a D300 though). Also, Tokina uses an unusual "focus clutch" mechanism in their lenses. The entire focus ring is slid forward or backward to engage or disengage autofocus. When it's set to AF, the focus ring doesn't do anything when rotated. This is done to protect the micro motor focus drive they use from damage when it's overridden by manual focus. It forces you to shift the lens into MF mode first.
On the bright side, this might not matter to many macro shooters who prefer to only use manual focus anyway. They can simply shift the lens to MF and are all set. But it can be a problem for shooters wanting to use AF, but also needing to "tweak" or fine tune focus manually. Can't do that on a Tokina lens... you have to first shift it to MF.
Nikon AF-S & AF-P, Canon USM & STM, Sigma HSM, Tamron USD and many other lenses allow "full time manual override" of autofocus, without having to turn off AF and with no risk of any damage being done to the lens' focusing mechanism. This allows for quick, easy manual fine tuning of focus that's often needed with macro... As well as quick de-focus/re-focus technique with AF.... and possibly some other things that simply can't be done with the Tokina lenses. There is a new Tokina ATXi 100mm f/2.8... but it appears to be identical to the AT-X version, aside from some cosmetic changes.
The
Sigma 105mm f/2.8 OS HSM lens is a virtual copy of the Micro-Nikkor 105mm..... That Sigma used to be more expensive too. But has been on sale lately, discounted to around $450, which is less than half it's previous price!
There are two different
Tamron 90mm f/2.8 Macro lenses... a more affordable one (around $500) with a slower micro motor focus drive and a more expensive one (around $650) with faster ultrasonic focus and image stabilization. The lower prices lens also isn't internal focusing (neither are the Tokina 100mm lenses). This means it grows in length considerably as the lens is focus closer. that reduces available working space between the front of the lens and your subject. It can be as little as 4 or 5" at full 1:1 magnification, with lenses in the 90mm, 100mm and 105mm focal lengths. The pricier Tamron, the Nikkor 105mm and the Sigma 105mm are all IF or "internal focusing" lenses that don't increase in length when focused to their closest.
There also is a nice
Tamron SP 60mm f/2 Macro that's crop-only and would be fine on your camera. It's a full stop faster (f/2) than most macro lenses. That makes it nicer for portraiture too. Around $500, it doesn't have image stabilization and uses a micro motor focus drive that's fine for macro and protraits, but not an "action" lens. It is an IF lens, which is good since a shorter focal length like this naturally has less working distance at it's highest magnification.
There's a
Sigma 70mm f/2.8 Macro, too. It's relatively new and am not all that familiar with it. I know they made one some years ago, so apparently have decided to bring it back again.
Nikon themselves makes a number of different macro lenses (they call them "Micro", though). They are reportedly mostly quite good, but I can't say from experience because I use a different system. I'd encourage looking at 90mm, 100mm, 105mm primarily.... maybe 60mm or 70mm, if you want a somewhat more compact lens and don't plan to sneak up on shy insects.
First of all, learn to ignore much of what Ken Roc... (