We camped several times in Glacier national park in our maggiolina tent in 30-40mph gusting winds and rain every night. We slept like babies. Then again, those tents are VERY ruggedly built.
I'd say any well built "taffeta/poly cotton fabric-over-a-frame" style RTT would likely flap quite a bit, but would fare very well in a storm, since it'd anchored to a vehicle. What direction a car is faced isn't as important IMO as WHERE it's parked. If you can park in the shadow of a large boulder, or amongst a sturdy stand of tree's, it's been my experience that the effect of the wind and rain is much lessened.
Ground tent? It's all about profile, pole quality and staking.
A nice low-pro REI or mountain hardware tent properly staked with a good rain fly is likely going to be just fine.
Pretty sure they used springbar canvas tents up on everest, so it would seem that those are on the sturdier side, too.