As a rule of thumb: the heavier the better in terms of vibrations. wooden tripods can be very great, but very heavy.
well, now it all depends on what you want to use the tripod for...
if it is for long exposures, then it has to be sturdy/heavy.
If it is for long telephoto shots, then it has to damp away all those vibrations. with a 300mm lens you already see the shake due to the SLR's mirror swinging up ... with some cameras you can lock the3 mirror well before the exposure though, so the vibrations can be damped away in time.
then there are the tripod heads ... they connect your camera with the tripod.
there are ball heads which allow to quickly swing around the camera in all directions, or panorama heads for panorama shots ... and many more
so, what would you like to know? this is a wide and vast field ...