Which brand and model of street lights in your area has been spot replaced the least and was least prone to premature failure, vs what was the most prone? HID and LED street lights.

Which brand of HID cobra head, NEMA head, post top, flood light, etc (specify mercury vapor, probe start metal halide, PSMH, or HPS depending on what is used in your area, if more than one of these types are used, let me know), as they use different ballasts and one type may be more prone to failure than the other (and HPS, PSMH use an ignitor, which can fail), and which brand of LED cobra head had the best longevity?

Do not count cycling bulbs as a failure, as bulb cycling is a lamp failure mode, not a fixture failure.