Unraveling Structure-Property-Dynamics Relationships in Functional Crystalline Materials with Cutting-Edge Diffraction and Spectroscopic Methods