Frustrated Classical Spin Models: Equilibrium and Dynamical Properties in Connection with Real Materials