Geometrical magnetic frustration in pyrochlore and multiferroic compounds: what can we learn from neutron scattering?