I would be very picky if looking at any herding breeds. I have horses and have had cattle and have dealt with various herding breeds. They may be fine on the trail, but they tend to cause issues with people on the down time at home. Their brains are always going and they need "something to do" all the time. Border Collies are one of the most numerous of dogs dumped at shelters.

Aussies, in my opinion, are 50/50; buy from a breeder where you can mess with the parents to get a feel for their hyper-ness.

I would honestly look at the breeds used in the service industry for service dogs. They possess the traits a camper/hiker would want.

Retrievers seem to be good "all-around" dogs.