Originally posted by Bryce K I would guess that a slower autofocus when shooting in macro in many cases would not be a huge issue since you would be shooting stationary objects. Am I wrong in this? Also do many people go to manual focus in those instances?
Just so. And that is why highly regarded manual focus macro lenses, like the Pentax-A 50mm f2.8 macro or the A 100mm f2.8, remain popular and hold their value very well.
Macro lenses tend to have long focus throws, and that is why on autofocus versions the autofocus is often slow. That can be an irritation in general (non-macro) use when trying to track moving objects (including children and pets). But the rest of the time it doesn't matter much, and their stellar sharpness makes up for it.
I'd put in a word for my Pentax D FA 100 Macro WR. The image quality is excellent, great colour rendering, 1:1 macro, lovely portrait lens, compact, beautifully built, weather resistant. Just a fine lens.
Others will make a case for a 35mm or 50mm macro. For example, have a look at these superb flower shots taken with a 35mm macro:
https://www.pentaxforums.com/forums/12-post-your-photos/274328-nature-flowers-australian-national-botanic-gardens.html
But for me about 100mm is my preferred focal length for macro, because it gives a reasonable working distance from subjects such as insects. At 35mm, or even 50mm, for me there would not be enough distance from the subject at 1:1 macro. Also, at 50mm I prefer to have a faster lens (e.g. DA 50 f1.8) than the f2.8 of most macros. But, as they say, YMMV.