To enhance the stability of wood and decrease restrictions on its use in the furniture industry, hydrophobic modification can be employed to confer waterproof, anti-fouling, and self-cleaning properties. The present study outlines the preparation of silica sol using the sol–gel method, followed by impregnation and chemical vapor deposition methods to modify the sol. After grafting 1H,1H,2H,2H-perfluoro-decyl trichlorosilane (FDTS), hydrophobic and superhydrophobic properties were imparted to the wood substrate. To explore the correlation between the surface properties of the wood substrate and superhydrophobic coatings, the densities, porosities, and surface roughness of various tree species were compared. The results showed that the sol–gel method successfully constructed hydrophobic coatings on different wood substrates, with six samples (poplar, elm, toon wood, paulownia, ashtree, and black walnut) achieving superhydrophobic surfaces, with densities ranging from 0.386 to 0.794 g/cm3, porosity ranging from 13.66 to 42.36%, roughness ranging from 4.660 to 11.244 um, and maximum water contact angle of 165.2°. Whereas beech and rosewood only reach the hydrophobic surface. Although the coatings demonstrated good resistance to water, pollutants, self-cleaning, and chemical agents, further improvements are necessary to enhance mechanical wear resistance.