I also have for the past 26 years worked for a shop that never has seen much less used a megger, I asked once if one could be added to our inventory and after looking up a price from the local supplier, was told we haven't needed one in all these years for that kind of money we don't need one now.
But my first experience with meggers was in industrial, and one of the best eye opener I had was when it was explained to me in how they differ from a regular ohm meter, was that if you take a set of contacts and open them about the thickness of a couple papers thick gap, and use a ohm meter, it would show all is fine, but put a 500 volt plus megger on it, and it will fail, as it would arc over, this is the same thing when you have lets say an underground feed to a post light, you ohm it out and all seems fine, turn the breaker back on and it holds, couple days later customer calls and complains the breaker is tripping again, now what happens that is so random?
Transient voltage spikes, these little spikes that motors and ballast tend to kick into the circuits can sometimes can be a few thousand volts, the bad spot in the cable starts to arc over and the current increases till it trip the breaker, but you go back there and reset the breaker and it resets, till the next inductive load is turned off, in this building or one down the street.
The funny thing is, if you would place a TVSS on this line, it probably would have never been noticed until the line totally fails, but a megger would have found it the first time.