Most of my shooting is with a tripod. As a TexPhoto accurately pointed out, what you want is a quality tripod where quality is dependent on your useage and shooting environment.
The material of a tripod does not indicate its quality!!!! Just the price. :-\
I happen to be very happy with the Manfrotto line of tripods. Good quality at a good price. I have three of them and a few monopods. Never had one fail on me yet.
As for vibration dampening, it is more a factor of design than material. As previously pointed out, a poorly designed tripod is a poorly designed tripod regardless of material.
My free, and worth every penny, advice: Go to a photo store and fondle the AL tripods. Put your camera on it and give it a try. Only if you truly find that there are no AL tripods that are good enough for your purposes, then consider spending the extra money for a Carbon Fiber-Reinforced Plastic tripod. Carbon fiber is not some magical material. And of course not all Carbon Fiber-Reinforced Plastics are the same.
The bottom line is that you need to find the tripod that is best for YOU and YOUR shooting. Like everything else in photography, there is no best, only best for you. There is, unfortunately trendy......
Good luck with it.