I would echo others' sentiment on the Hornet 2p. I really like mine - it's a super awesome tent - but no way in heck it is a pragmatic 2p tent. It fits me and my junk and that's about it. The 1p version is probably just wide enough to snugly fit your sleeping pad. It is very well designed and constructed for its purpose and goes up pretty fast.
I also recognize that it is a 3 season tent built with very light materials. I do use the optional footprint to prevent durability issues. I can't imagine too many issues with wind if the provided mid-height guy-out points are securely fastened, though I admit I haven't had it in high winds and there is a good bit of airflow through it due to the caternary cuts in the fly, which was a primary driver for buying it.
If you are at all worried about durability and inside space, I would go to a Dagger, maybe even the 3p version for 2 people. It's bigger in nearly every dimension and built with more durable materials, which makes it weigh about 50% more, though that's still pretty darn light!
Personally, I would love the few extra inches of head height and length. At 6'1", my head and feet are real close to or touching the walls when in my bag. Also, sitting up on my bag & pad, I just barely touch the top of the tent with my head. I think that the extra weight of the Dagger would be worth it for more than a handful of nights or a day or 2 of crappy weather, especially considering the durability improvement due to the heavier materials.
No experience with the MSR but have only heard good things.