So what is YOUR Ultimate Outdoors Tripod, version 4?
Nothing is Ultimate, nor is anything Perfect.
My main tripod use is flower macro - often on the ground, and in awkward positions.
I opted for a Gitzo Explorer with an offset "centre post" that will extend in any direction and any angle from straight up to almost straight down.
Equipped with custom made 125 mm long (5") spikes which stick into the ground, it won't tip over even when the centre of gravity is beyond the feet.
The legs have no "click stop" positions, but lock in both directions (inward and outward) for added stiffness, stiffness being the key, not strength.
With an Acra-tech ball head, the total is not too heavy. I carry the camera, lens, and ballhead all on the tripod over my shoulder if I hike any distance - and I usually know which lens to take.
Hiking poles would be a nuisance - and they usually come in sets of two, not three.
Glenn