Quantum-Enhanced Metrology with Engineered Squeezed Light: From Spectroscopy to Inertial Sensing