The points you mention could apply to a dog of any breed. Many are destructive, which I perceive as one reason for the popularity of crates, which when I was growing up were pretty much unheard of other than for use by breeders at dog shows. But our society has changed, dogs are often left to their own devices at home, busy schedules prevent people from doing the training necessary, etc.
I have owned five Basenjis. All different. Only one really persistent climber.....yes, chain link can be a ladder.....but even he could be thwarted by hanging PVC pipe just under the top of the fence, and another obvious solution is a physical fence backed up by "invisible fence". A digger or climber isn't going to pursue that route if being close to the fence is uncomfortable. But my boy much preferred to be inside, so his climbing was seldom an issue.
Blocking off an area inside the home may be trickier, but again, there are solutions. The "cheap & dirty" one would be a barrier backed up by a "scat mat", something that worked for me when my husband and I didn't want canine company, or to have our bedroom door scratched to pieces! (again, the culprit was the boy, the girls never wanted to participate!) There are always solutions to problems, with a bit of patience and inventiveness, and it's entirely possible that the dog you choose won't present too many challenges. You could opt for another breed and end up with exactly the issues you are trying to avoid!