Another important consideration is the design and quality of the tripod head. A ball and socket head is quick to adjust, but needs to be done up tight, meaning cheaper ones are crap with DSLRs. Good quality ones can be quite expensive. 3-way pan and tilt head might be more secure, and better for fine adjustment, but agins, cheap ones can be crap. Video heads often use a ‘fluid’ system to keep them very smooth while panning/tracking, but can get very expensive. The better tripods such as Manfrotto, can be equipped with different heads for different purposes. A very useful addition is a QR plate, which allows you to mount/remove the camera from the tripod much more quickly and easily.
Tip: hang a heavy bag on/from the legs, to give extra stability. A lower centre of gravity helps make the tripod more solid and less prone to wind etc.
*Just seen the equivalent to my old Manfrotto would now cost £200 or more. 😯