What else could Weir/Scott have done to strand Watney on Mars while getting the rest of the crew back to the ship? Any ideas?
There being a massive sandstorm alone should have been enough, sandstorms on Mars can be damn severe even with the low air pressure as it can damage/degrade equipment (like I said, it can be likened to putting something in a sand-blaster) and sandstorms on Mars can envelop the entire planet and last for weeks or months. So any sandstorm during their mission, especially if it had reached higher categories, realistically wouldn't be a risk from the wind speeds but the presence of it alone could potentially negate anything they could do for the mission and could put their lives at risk if some of their equipment were to fail, or the storm had the potential to last long enough to make their solar cells incapable of maintaining their shelter.
So, not much needs to change. The characters determine that the storm is a mission-ending event given the risks of it and early indications show the storm has the potential of lasting a long time. Given the lag-time in communications to NASA the crew has the latitude to make the call to abort the mission in the name of their safety and Lewis makes the call to abort. (This could even play more into the "mini-arc" of her being nervous on her first mission as commander and unwilling to take risks or endanger the rest of the crew.)
Enroute to the MAV the electrical activity caused by the storm interferes with communications and restricts visibility making it difficult for everyone to see and communicate with one another. Watney, rather than being struck by flying debris -as realistically it wouldn't be moved by even the strongest of storms on Mars- trips, stumbles, falls or is otherwise made prone by trying to move through the storm, as he goes down he strikes the head and some other part of his suit on a rock, this not only knocks him out but damages the sensors on the suits (or he falls on one of the little flags around the camp that impales him, as the dish part does in the original movie) showing him to have a suit-breach and loss of life-signs to the rest of the crew, who cannot reacquire contact. Pretty much the rest plays out the same, they can't relocate him and the "window" for launching is narrowing (In this case, the MAV wouldn't be vulnerable to tipping due to the wind forces (which, why would this be a thing? Does this mean the MAV for the A-IV mission is standing there vulnerable to falling over if the right kind of storm comes along) as either the alignment between it and the Hermes is starting to become unideal for a rendezvous or the stronger part of the storm has yet to reach them yet and the conditions for launch are about as ideal as they're going to get. It's now or never. Lewis makes the tough choice to leave.
For his impalement, it may have to be when he falls he lands on the communications array, as that's why he was unable to contact NASA in the movie (the communications dish was damaged in the storm) and this would still need to be the case here. Or the communications system was dependent on the MAV which, being gone, can no longer allow him to contact NASA.
And if you ask me, the sound of a sandstorm spattering against the hull/tarp would probably be more alarming than the sound of wind. Think of the last time you were in a sleet or hailstorm. Was it a soothing sound?
Well, I like severe weather and I have a car-port so, yeah.
But, in storms when there's howling, strong, winds it can be a bit alarm when you consider trees, power lines, etc. around and how those howling, strong, winds when it comes to weather on Earth is almost always associated with very strong storms and tornadoes in the Mid-West and hurricanes in the south and east-coast during the right times of year. But, I'm not bothered by the sound of wind either.
But, in the movie the action of the tarp going in and out of the port as the winds howled struck me as something that would be alarming in that situation and it was easy to connect with. He's in this place and the thing between him and death is the tarp and it's flapping in and out of the hole in the storm.
The sound of any sandstorm would be loud and probably just as dangerous -or more so- but I don't think it'd convey the message as well. (Incidentally, there were numerous times in the movie where there were apparently sansstorms outside that we saw through the hab's windows along with lightning.)