I think the basic rule of thumb is to use it with Hypercharge and to keep them lined up. There are of course situations (such as fight transitions) where it's a dps gain to blow it up early since you'll have the downtime to get it back up after reset debuff.

Fairly certain everything but Dragon Sight affects turret damage so I'd assume the same for Overload but tbh not sure, good question.