The tripod is the most important tool besides the camera, so I usually don’t compromise unless it’s a long multi-day backpacking trip.
The combo I use 90 percent of the time is a Gitzo 1325 set of legs and Kirk BH1 ball head. Whenever possible, this is what I am carrying.
For backpacking, its a Manfrotto 3444D set of legs (carbon fiber, 4 section) with the center post cut off and a manfrotto Proball 308 with a modified arca swiss QR attachment. I am not even sure they make those legs anymore, but it is a great backpacking tripod.