1. Suralux 10w tube and 15w tube. On the 10w tube they forgot to dip the electrodes in emission coating, so it doesn't start on electronic. On the 15w tube, they made it the wrong size (F14T8 instead of F15T8) and they got the phosphor color to be 5000k though it's labelled 6500k.
2. Madhab neon flicker flame lamp. I have no issue with the glass part of the lamp, it's the base. Its made of cheap bright flashy plastic, and the B22 pins are plastic too. The B22 contacts are just screws. It just looks too hideous. A metal B22 base with ceramic filling would look 10 times better.
3. Philips 15w blue glazed incandescent. Blue glaze is a very dim color, not suitable for a low wattage like 15w. Hence, the lamp is half as bright as a small led, and consumes 15w. The other 15w incandescents like green, yellow and red are brighter than the blue one. I don't understand why they didn't use translucent blue lacquer instead of blue glaze.
4. Mysore 160w SBMV. They used the design from philips, who made a flawed design. They placed the starting electrode too close to the main electrode, which meant mercury would short the electrodes resulting in the lamp shutting off after 10 secs. The lamp had to be run at a 45 angle to even function.
These are just non-LED lamps. I have had many brand new led lamps just burn out minutes after they were turned on. Like this led bulb and this led strip.
Worst fixture I made is putting 6x 18w led spotlights of different colors in a 250w HID fixture. The hideous fixture is here.
There was also an idol frame that had leds on it, but it's power supply was horrendous and dangerous.