IMHO, Single wall tents are fundamentally going to have a lot of issues with moisture building up on the interior. Fine if you are in an area of low relative humidity and winter camping but not so good with east coast hiking where the dewpoint is not that far away from the air temp. A single wall tent doesn't breath and it will get damp inside just from the amount of vapor coming from your gear and body. That is the nature of the beast. Cuben Fiber (AKA Dyneema CCF) and Silnylon are effectively waterproof when new and properly seam sealed. Here is link to a Dyneema description
https://www.hyperlitemountaingear.com/pages/hyperlite-technology. Both fibers are a bear to sew and are mostly used by cottage manufacturers. Some folks swear by properly set up tarps as an alternative although they tend to be more popular in the west coast. They inherently have more ventilation but require ideal setup. HMG makes the Echo 2 which is system consisting of a conventional tarp, a "beak" which aids set up in windy conditions and an interior screened insert with floor. They used to make an Echo 1 but I don't see it listed. When I was shopping for a PCT tent several years ago (hike didn't happen) the Echo 2 tarp only or possibly with the beak was popular as a solo tarp several years ago as it was roomy enough for one person with gear and big enough to avoid touching the roof (its still quite low). I did not pay retail,as the one I purchased was an overstock of a a special forces version (Iraq war camo). I haven't used it nearly enough. it definitely feels "crinkly" to the touch. Its a laminate while Sylnylon is a coating that is saturated into an underlying nylon base. Pound for pound Dyneema is stronger in tension than nylon and one variety is used to replace steel cables.
Yes they all are thin and potentially fragile fabrics, that's why mainstream companies do not typically sell them as they don't want the warranty hassles. They also have a limited lifespan in sun. Definitely not something to set up in the front yard for a few weeks. They are also subject to melting so avoid campfires that throw sparks.