This is a great thread.
I actually don't even like making recommendations on cuben fiber to someone who has no experience with it, just because I think it is important to feel/hold several weights before making a decision. I usually tell people to order the sample pack and get an idea of what they're getting into and then we can discuss options. The weight of fabric suitable for each application really depends on the conditions, terrain, weather, site selection, user expereince, etc.
N2 Tarp (0.33 oz/yd): Designed for low level forested areas where natural windbreaks are plentiful.
All-WET (0.74 oz/yd): Designed for exposed areas where full body coverage is required from the elements (wind, rain, etc.)
Also, I think it was Thom Darrah who had a custom tarp made from cuben fiber (1.5 oz/yd): Designed to be used above treeline and withstand substantial wind/rain/elements.
So it really does depend on it's intended use.
With that said, I've been using the 0.33 stuff for a while now and I feel there is potential for it to be used more and more. Remember a few years ago, everyone was super worried about the 0.6 oz (now 0.74 oz) stuff and now it is considered bomber (which I agree with). Who knows, in a few years we all might be using sub 2 ounce full sized tarps.
As for the tarp in the video link above. The N2 tarp has literally amazed me with it's performance. I thought FOR SURE it was going to get torn to shreds in Zion while camping on the mesa but it held strong all night through the wind and rain. I wouldn't consider it a crazy storm or anything, but that was the worst that tarp has been exposed to. I have much more confidence in it now. Based on that night, I did some more tieout tests on the 0.33 oz/yd CF and was really happy with the results.
0.33 oz/yd Tieout Test
In the tests, yielding in the superior performer occurred at about 80 lbs. Have you ever lifted an 80 lb dumbell? It's freakin' heavy! I realize there is more to tarp stresses than a simple hang test, but it gives you an good idea of its ability. I can't wait to read Chris Lucas' article on testing cuben fiber. People are usually afraid of the unknown so it will be nice to put some solid numbers to the fabric.
I think pushing the limits is fun and exciting. Its what I enjoy doing and there are others out there who are like minded. I get e-mails asking to buy an N2 tarp all the time (I don't sell them) so if anyone wants to make them, go ahead.