I work for a company that has communications towers all over the country, each with a specific unit number. The towers all have different assets attached to them. Those assets exist in a block catalog. I have a script for each tower that inserts those blocks at the appropriate location. Each tower is 1 drawing, and they are all unique. Also included in the script is the creation of property filters and their definitions (wildcard criteria), layer color assignments, etc.
It is possible the script solution is not even the best practice, but it is what I came up with. But then the scale of the project kept growing to the point where I am searching for something more automated instead of manually dragging and droppping hundreds of scripts and opening and closing .DWG files.