Quantum geometry effects on superconductivity, light-matter interactions, and Bose-Einstein condensation