Near-Unity Indistinguishability of Single Photons Emitted from Dissimilar and Independent Atomic Quantum Nodes