The Role of Formation Location in Shaping Sulfur-, Nitrogen-, and Carbon-bearing Species in Super-Earth and Sub-Neptune Atmospheres