This is the tent I bought. Its not on sale on amazon prime anymore but you could find it other places online. It fully zips up on all the windows so it should hold out most of the dust that would come through a mesh tent.
Backpacking if you're just using it like 3 weekends a year? Naturehike
Car camping? Coleman 4 person cabin tent $84.
I personally used an 8 person cabin tent for over 2 years for just me car camping, it was nice having the room but it wasn't "instant". I recently downgraded to a 6 person instant cabin tent.