Diamond is usually selected for non-ferrous materials, ceramics, glass, stone, carbide, and composites.
CBN is the better starting point for hardened steels and ferrous alloys. The right choice depends on workpiece chemistry, process temperature, bond system, and surface target.