I don't have lots of experience with all the various lightweight shelters out there but I do have a rainshadow 2, so I can speak to that tent.
The Rainshadow 2 has quite a bit of room. I'd say it's a pretty legit three-person tent in terms of usable floor area. I often use it for trips with my girlfriend and our 90 lb dog. It's more than enough room for the three of us. Without the dog, it starts to feel palatial. By myself, it would be way over the top in terms of size, but not really that much of a weight penalty over say, the Squall 2, in the bigger scheme of things if you're trying to get by with a one-size-fits-all approach to your shelter.
On the other hand, if most of your trips are with just one other, you might be able to squeeze yourself plus two kids into a slightly smaller 2-person tent on the occasional basis. This would cut down the weight a little. On a lot of the tarp tents you can flatten out the bathtub floor when rain isn't expected to gain a little extra usable floor space.
Set-up is easy. Workmanship on all of the tarptents is top notch. Stormworthiness probably depends on where you live and what kind of conditions you anticipate to use it in. Where I camp, we get wind and rain (not very much of it though) and the tent has worked great so far.
The only thing you'll probably need to work on a little is managing condensation. This isn't unique to just this tent though, it goes for just about all single wall shelters. Pitching the rear end into the wind, utlizing a higher pitch in nice weather, leaving the vestibule (and if possible, no-see-um doors) open will all serve towards effectively managing condensation. Obviously the amount of condensation in the tent goes up with the number of people sleeping in the tent.
If you haven't already, try giving Henry Shires a call or email and ask him for his input. He's been super helpful with trying to select the right tent for the right needs.