Still, there are lots of things you can do to ensure a tent will survive all but the very worst weather. Start with where you set it up. If the wind feels like a problem, then try to take advantage of the landscape, erecting the tent in a draw, or in the lee of trees or boulders. Point the low end of the tent (usually the foot end) into the wind, or in the case of a dome tent try to align it along the prevailing wind direction. Stake it out completely, using every stake loop, so that the wind can't get under the tent and start to lever it. Guy it out using every guy loop and taut lines. I don't think over-tightening was a problem for youyou want taut guy lines, as they help prevent the tent from whipping back and forth. Shock-corded guylines, though, may help reduce wind-loading by letting the tent lean a little bit when hit hard by a gust. Some tents can also be used with internal guylines. If so, use those as well.
Then, hunker down and tough it out. If you really think the wind is about to demolish your tent, consider removing the poles and simply using the tent as a sort of bivy shelter. It won't be comfortable, but a broken pole's sharp end can be considerably worse.