I own a couple of single walled tents, plus a Gatewood Cape, plus I've slept under a more traditional poncho. Done a lot of nights in single walled tents, so I think I understand their dynamics pretty well.

I've got multiple double-walled tents too. Most are IMO too heavy to want to carry; fine for car camping or similar use.

What I like now is the Lightheart Designs approach, a sort-of double walled tent at more like single-wall tent weight. This design works really well for me, and is in general my go-to tent now, even when I'm not camping in my native ("it gets wet here") Washington state. SMD makes their own clones of the Lightheart design, maybe others do now too (I've not kept up).