Will an DVM set to resistance have any success in finding the fault in the circuit once the load is disconnected?
Yes and NO, depends on the type of fault/short. dead short YES, high resistance fault caused by carbon, water ECT maybe maybe not.
RIGHT TOOL FOR THE JOB is always important. I mean you would not use your Klein's for a hammer? Would you? (BAD EXAMPLE)
I have been involved in several projects were electrical contractors had employees that relied on a multi-meter to verify a board was clear of a fault and due to this oversight they increased the damage and exposed themselves to physical injuries. I have also been on calls were electricians, just reset the CB and they ended the day in the hospital.
The proper safe procedures for checking all components of a distribution system should always be used.