I tried to mod the light: WorkshopTurretSpotlightLight01, setting it to shadow spotlight and increase radius, this is how I came across this:

If I place it and then turn away to the opposite direction, then its still working fine casting 3rd person shadow and rotating the light etc, after walking away some (not that far) it stops rotating around, the light is still on but no movement,

or it moves (more likely) but the rendered angle going to be the same as it was exiting this "distance".

If I turn around and face it it resumes moving but NOT where it stopped, turning away would stop it again unless you reenter the "distance".

You can't really test this in vanilla setting cause of the 1024 radius,

so set the WorkshopTurretSpotlightLight01 radius to 4096 for example

or get a mod with increased lamp radius or whatever in the description and try.

My question is, where I can increase this distance?

Point me to the right direction please.