Janus-faced influence of Hund's rule coupling in correlated materials