Coleman tents (actually sold at Walmart) are truly decent tents, especially in terms of being water-tight. You can go with some higher end brands, but honestly if you're camping out of a car and not hiking your tent into somewhere remote it's not worth the added cost. I used the same Coleman dome tent for the past 8 years or so, and it's still to this day in great shape, and has never leaked.
The only drawback of most any dome tent is their resistance to wind, as they're prone to "fold up" in really strong gusts. I actually like this one pretty well, and it's a more upright structure which should be a bit more sturdy, with added head/shoulder room:
http://www.walmart.com/ip/Coleman-Montana-Tent/15840118
Edit: I guess they changed the Montana Models, this looks more like the one I was thinking of:
http://www.amazon.com/Coleman-17-Foot-10-Foot-8-Person-Modified/dp/B000W7BHJY/ref=sr_1_1?ie=UTF8&qid=1305218153&sr=8-1