Simplistically, CBN for sharpening high speed steel tools, diamond for sharpening tungsten carbide cutting tools.
Diamond is harder than CBN, but CBN is a far better conductor of heat than diamond so in moderation, it can be used dry without overheating the steel.
Don't use soft sticky stuff...