The best performing shoe that I have found for sandy and rocky trails is the Speedgoat by Hoka One One (available on Amazon).
The Speedgoat (available on Amazon) has shorter lugs set into a closely spaced tread pattern. These shoes sport the durable Vibram soles (wikipedia) using the same rubber compound made famous on top end mountaineering boots dating back to the first ascent of K2.
Like all Hoka One One shoes, the toe area feels a bit tight when the shoes are new, but they soon stretch to your foot shape. For me the sensation of tightness was gone after the first 10 miles, and after that they were great.
The standard fit has your toes right at the front of the toe box so I would suggest that you get a half size larger than you would normally. The (W) wide fit Hoka One One shoes have a wider toe box and if you can find a pair of those, snap them up because they sell out quickly.
I live in a dry climate with fairly hard pack trails covered in a thin layer of loose sand and small stones. The tread pattern of the Speedgoat (available on Amazon) combined with cushioning that is kind on my knees makes this my go-to daily trail shoe.