The Opacity of Spiral Galaxy Disks V: dust opacity, HI distributions and sub-mm emission