Advanced Superconducting Nanowire Single Photon Detectors for Photonic Quantum Technologies