To keep it really simple, photographers who use a tripod a lot, tend to go for a tripod that is heavier, less subject to vibration or wind resistance, less likely to slip on uneven ground, and with a smooth and secure head that moves when you want it to move and stays absolutely still when you stop moving it. Those that are rough with their equipment also are looking for heavier material in a tripod to prevent breakage. The downside is of course carrying it around, setting it up and taking it down.

Everyone of course wants a tripod that can be set up and taken down very quickly and is fast and flexible in terms of adjustments for height etc. Bubble or even laser type levelers are present on some tripods, as well as click stops on the head for panorama shots that can be stitched together with software.

Those photographers who do not use a tripod as often because they are doing photography on the fly or in spaces that do not allow for a tripod, often tend toward a lighter tripod with great flexibility which can reduced down to a small size or easy carrying.
The head and extra features are not as important because the tripod is not used as frequently.

Decide what type of tripod and how much to spend, based on your projected tripod use, particularly in terms of frequency.

Ronnoco