So, there is actually a pretty interesting reason for those LEDs that still light faintly when off.
Depending on what kind of power supply is used in it, there is a small chance a tiny amount of current could leak through it, even if it isn't the full supply voltage.
Most higher quality bulbs have components specifically used to prevent this - but cheaper once often don't.
Now, depending on installation, cables running close together in a bunch can induce small amounts of current into each other.
Normally, that amount of voltage and current is so low that no other lighting technology can do anything with it.
However, because LEDs are THAT efficient, supplying even a few volts and milli amps can cause a faint glow.
I was installing a light fixture in my last flat up north that still had much of the early 50s wiring.
Had my multimeter out and checked that there was no voltage before commencing installation.
Always measured 6 volts, unless I turned all the breakers to the kitchen off. Couldn't measure any current as it would just collapse as soon as I tried to measure it.
Sure enough, the bulbs in there sometimes glowed ever so slightly.
Looks really quite spooky IRL.
I think due to the EUs higher voltage that issue is somewhat more common.