[ZHA] Fix light effects not turning off sometimes

[TheJulianJES]

See:

• ZigBee lamp fails to switch to colortemp mode from a scene when colorloop effect active home-assistant/core#153431

The effect stuff needs a rework in general, also to support Hue effects in ZHA.
The underlying issue is that we only disable the effect at the end of the turn_on method, after we supposedly already set colors/temp. Ref: https://github.com/zigpy/zha/blob/cd86906d77bb947ead5ae31f7970a24f18608925/zha/application/platforms/light/__init__.py#L476-L485