What I've seen is that many folks just use ordinary tents. Probably get away with it for a year or two, then the wind hits them, and they are trashed. I guess then you just buy another one!
I guess what I'm saying is either go WalMart or go expensive. The ones in the middle will still fold in a good wind. If you buy it knowing it is temporary, you won't feel cheated.
Guy I camped near last year had a home-built dome tent that he could stand up in that was very sturdy and held up perfectly to the wind. He had a big SUV and a small trailer to haul it with, and I believe it took him several hours to erect it. Also there was a woman who travelled with her mother and occasionally other friends/relatives. She had TWO big canvas tents, connected by tarps into a regular tent compound, and she traveled with a big cargo trailer.