As a general rule, if you're sanding to remove material...gross shaping...that would best be done dry.
If you're sanding to finish...smoothing a surface, removing fine scratches and that sort of thing...that's always best as wet sanding. In some cases, depending on the material being sanded, the wet-sanded material may actually act as an additional fine abrasive to polish out your finish.