I just got a Nikon D3500 and would like to get a macro lens to take pics of coral etc. I got the D3500 kit from costco which includes 2 lenses which are fine for general photos, but neither are great for macro shooting. Granted I am new to DLSR shooting, so some of the terminology is beyond me at this point, but I would like some advice on a good macro lens to buy, preferably used, that would be a good all purpose tank lens. I was reading about the Tamron 90mm, but some are saying its good for top down, sandbed shots, but a 60mm might be better for frontal shots and frag tank shots. I have a red sea reefer 450, so I'm looking at about 20" of water max, but most would be about 14-8" deep. And I doubt I would do a lot of top-down shooting right now except for my very shallow frag tank.
Also, the camera's specs say "Autofocus is available with AF-P and type E and G AF-S lenses". Would I want a macro lense with autofocus, or should I just get a manual focus?
Also, the camera's specs say "Autofocus is available with AF-P and type E and G AF-S lenses". Would I want a macro lense with autofocus, or should I just get a manual focus?