I have stands that are about as good in any wind, because deer can come from literally any direction. I have other stands that you need to be careful with.
Basically a stand should be positioned so that the prevailing wind does not blow your scent in the direction you expect deer to come from. After that, you can ckeck the wind before you hunt to see what it is doing on a given day.