[Enhancement]: Higher verbosity in backup restore job

### Problem Statement

When restoring heavy backups, it takes forever for the job to complete and the only log we get is "Restoring backup file..." which causes little anxiety and puts us in a blank state as we get no information or how much it has progressed.

It would be nice to add verbosity to the restore command so that user also get to know what's happening under the hood.

Ref: https://support.frappe.io/helpdesk/my-tickets/64665

### Proposed Solution

Add `--verbose` flag to the command

Locate the backup restore command and inspect how it currently logs "Restoring backup file...". Run the restore job with and without the proposed --verbose flag, then verify that verbose output reports useful restore progress or activity while the default behavior remains unchanged.

Written by the indexing model from the issue text.