It covers the city in sand. Like, it buries the entire city in the stuff. In a very Spec Ops/Dubai kind of way.
You'd be forgiven for thinking it's just a cosmetic effect, but no. Stick with the video above long enough and you'll see people driving all over the stuff.
If you want to try Desert Storm out, you can grab it below.
Desert Storm [GTA4 Mods]