I love it - we'll spend $25k for a motorcycle, but we're too cheap to pay over $200 for a decent tent! Too funny.
What do backpackers look for in a tent? Low weight? Strength and protection in adverse conditions? Flexibility for pitching the tent in less than ideal locations?
Seems these are the same qualities you'd want in a motorcycle tent...
So definitely check out the offerings from the various manufacturers of backpacking tents. The best brands are MSR, Mountain Hardware, The North Face, Black Diamond, and Sierra Designs. REI's house branded stuff is also well designed and constructed.
But if you can buy it at Wal-Mart, forget it. It will be too heavy, poorly constructed, and poorly designed. It won't come with sealed seams, a bathtub floor, or durable zippers and seams. Poles will likely be fiberglass instead of aluminum. It will likely die after one season of use. You want a tent you can abuse a bit - pitch it in dirt, let the wind try and knock it down, stuff it into a dusty sack and toss it in a side case. Spill coffee and bacon grease on it. It's your home away from home, so make sure it's dependable, useful and light.
Finally always set up your new tent for the first time in your back yard or in your living room. Never try to figure out how to set up your new tent at the end of a long day, in the rain, in the dark. Learn how to set up your tent in ideal conditions so you'll be ready to set it up in less-than-ideal conditions later.
I always set up my tent in the living room or back yard after a trip, so I can shake out all the dirt and dust, hose it off if need be, and pack it away in as large of a stuff sack as I can find so the material doesn't stay compressed when stored. You should also do this with your sleeping bag, down coat, etc. You can buy specialized storage sacks for tents and sleeping bags, or you can use large pillow cases. Whatever you use, make sure the fabric can breathe and isn't crumpled and smashed together when the tent/sleeping bag/jacket is stored.