When Is Diversity Rewarded in Cooperative Multi-Agent Learning?