My experience is that being coded in a particular hotel, or at least a couple I know of pretty much gets you pre-booked in a suite. Also, it has helped me get in at the last minute when sold out.
In any case, it's nice to know your business is appreciated.
My guess is that each property sets its own criteria for their individual status assigned. And this is not exclusive to Starwood.