In reply to Sir Stefan:
The durability of tent fabrics is more dependent on things other than hydrostatic head. The use of PU coated polyester vs Silicone coated nylon for instance. Polyester fabrics get weaker with thicker PU coatings, which results in a tradeoff between weight, tear strength (relevant in the light of UV degradation), and durability of the waterproofing. Silicone coated nylon fabrics are lighter and have a higher tensile strength, but are more sensitive to UV-degradation. The latter could be mitigated to some extent by re-applying the silicone coating every now and then (bit of a hassle, but more viable than re-applying a PU coating), although the cost of sil-nylon tents makes them less suited to general car-camping.
Hydrostatic head is most important on groundsheets, as this is the area that deals with most pressure and abrasion. Low hydrostatic heads will result in moist spots under your sleeping mat and other pressure points. 3000mm PU coating is the minimum for wet conditions, and 10.000mm TPU coating is the top-quality stuff.