it's not only about lens. you can have the sharpest lens... but without proper handheld techniques (if you're doing it handheld) you won't get a sharp shot. and be it on tripod or handheld, MF is still the best to get the moon shot really sharp. like what Rashkae mentioned, use Live View and magnify the image on-screen.