Spin dynamics in frustrated magnets: from edge- to corner-sharing geometries