I have a number of tents and have used them from beach fronts to over 19,000 feet in the Andes, and lower elevations in many other ranges in many conditions. I hear "tent sale" and I get excited thinking its really a tent sale and not a sale of cars, furniture etc.

+1 on what everyone has said about cost/quality: you get what you pay for. But consider primarily what and where you will use it (e.g, if rain is a possibility then a quality rain fly design is nice. If hot weather and rain are a possibility...a rain fly that allows good airflow over the tent; will you need to use a small cook stove in the tent; do you want to see stars?).

For car camping you shouldnt need the best; wieght goes down at significant price. You aren't packing it...so no worry. More important than weight might be the setup time, number of doors/ windows for ventilation, profile (to shed wind) and pole quality. Set it up in a store if possible.

If camping on sand; snow stakes are a must; a good groundcloth can save the floor of your tent too. One with a profile of the tent will cost; a larger profile needs to be tucked in to avoid bringing water under the tent.

Campmore is a good place to shop; find a "tent sale." And don't worry. There is no perfect tent; (If it gets bad, you can sleep in the car - yrs ago 6 of us slept sitting up in a junked '40 dodge we found in a field after rain soaked us out of our cheap tent) and most are pretty damn good compared to what I used in some incredible conditions in my adventuring days.