There's much useful advice, explanations given through this thread. My only addition is to suggest it's well worth reading up about the principles of tripod specifications/materials etc and on the few sources that make rigorous comparisons. This is essential to get beyond the brand advertising, and seine through many options on the market.
A great deal depends on why you are buying a tripod (s) in the first place. Thus not only weight of gear, and focal lengths, but above all, what are your Subjects, and how you photograph, and/or film.... So several factors determine tripod selection, and there's also the quality of the materials, machining, patented features etc, and all these ramp up the costs.
Thom Hogan has "tripod advice" articles buried in his websites.
Above all, the Center Column is essential reading IMHO
![]()
That looks like a great resource for objective info.