I feel your pain, I am doing this kind of boring task every day and trust me I have searched for a better way to do it. I also have submitted the idea to some 3rd party developers years ago but still nothing.
Tip : You can use LWCAD Cap Hole Tool to find the holes more easily, but it will not fix it the way you want unfortunately.