As someone who worked on a NASA Lunar mission (LROC), I can tell you that there are opinions both ways. With NASA on a shoestring budget, some scientists feel the best science return on investment is robots. But there are plans to put humans back on the moon that would not cost all that much more. If it weren't for the fixed budget, I'm sure almost all scientists would want manned missions.
Why? Go read some more about Harrison "Jack" Schmitt, who was on the Moon with Gene Cernan. Having a geologist on the moon enabled spotting things, making judgements, and then following up on the spot. Sending a scientist who can also pilot (and Schmitt was damned good) rather than only having military pilots changes the game as far as the science return.