Abstract: This talk will give an overview of the forefront superconducting radio-frequency (SRF) technology research and development being conducted at Fermilab and other laboratories. It will include the dramatic leaps in SRF technology that enable a series of highly efficient user facilities in basic energy sciences, nuclear physics, fusion and high-energy physics. Application of SRF technology in quantum computing and dark sector searches will be discussed. It will be a journey into the mystery of the SRF cavity surface nanostructure and will highlight the key role of surface science in the progress of superconducting accelerator technologies.