It all depends on how the DWG’s are structured.
If all Layers in the DWG have been used for all the different purposes (Lighting in a Lighting Layer) many things can be automated with a Dynamo script.
I’m working on Lighting from cad in the meantime.
Here is a little bit of what i’m doing.