Very interesting thread(s), the relationship between groundsheets, function, and failure.
Other than the obvious bit of skill that goes into all this (selecting ground cover for a campsite that drains well, is soft and not poky, etc.), here's how I focus my decision making, especially when using my primary shelter, which is a Locus Gear Khufu (Cuben) pyramid:
1. If all I need is a groundsheet on which to stay dry, then polycro (gossamer gear) it is. I take the largest size with me to provide lots of coverage for organizing gear on sloppy ground, etc. Much more durable than, say, a mylar space blanket or thin nonwoven PP (AMK Escape Lite bivy comes to mind), and very light to boot.
2. Now on to the inner tent analysis:
A – If you're looking for an inner tent primarily for bug protection in dry conditions, a Cuben floor, even a light one, should be fine. The pinholes will form, but in this situation, are repairable if needed, and irrelevant in terms of function. If you use a full length sleeping pad, then you have some elevation and are above any water seepage. If you have a lot of water seepage, then you may have to study campsite locations a bit more (finding well draining ground), or …
B – If you're looking for an inner tent to protect you from soppy ground and you have no choice but to locate your tent on soppy ground, then a high quality silnylon is the way to go. Heavier cuben starts to approach the weight of sil at a much higher $$, so it seems to fill an unnecessary gap between the more useful materials of light cuben and silnylon.
Now, nobody wants to own two inner tents. So if I had to own one? I'd probably get a cuben one, and in scenario B, add the polycro to the inside of the shelter as a second layer. This combo may just about be the weight of a sil floor, with more flexibility. There has been some suggestion that in this case, a water layer will seep through the pinholes of the cuben, pool between the cuben and polycro, and create a tub of water for you to sleep in. In theory, there's some fear in this assumption. In practice, it doesn't really play out…