How about adding a Create Backup checkbox to the warning dialogue shown before a catalogue refresh?
Its check state would be the default specified in the global preferences and clicking Yes to Proceed would work exactly as now but it would also give the opportunity to create/don't create a backup for that invocation only.
Cheers
Simon