Catalyzes the CoA-dependent reduction of elemental sulfur (S(0)) to produce hydrogen sulfide. hydrogen sulfide + NADP(+) = NADPH + sulfur hydrogen sulfide + NAD(+) = NADH + sulfur Binds 1 FAD per subunit. Belongs to the class-III pyridine nucleotide-disulfide oxidoreductase family.