I know you said NO trail runners... but perhaps you might want to reconsider. I did this about 3 years ago and it has worked out well. Here is some typical terrain for me:
These shoes (Salomon XA Pro 3D Ultra Trail Running Shoes) have been great. When I have get into a ton of lose sand, I sometimes wear XA Comp 4 GTX which keep the sand out with no other problems.
Other than that you might look at something like the Merril line, they have models with leather/mesh. I have no experience there.
For leather, I think Danner still makes the Mountain Light (right), and I have a pair that I wore for 20 years. Not light. Also, the best leather boot I have ever owned are Lowa Banff's (on the left). Gosh, digging up this picture makes me miss both those boots, but not the weight!!