status: hangs when ssh host is down

[johnyaku]

Bug Report

dvc status --remote hangs when the remote is an SSH host that is down for maintenance.

Description

As above.
Verbose output shows that dvc status hangs at

Querying remote cache

Reproduce

1. Specify an ssh remote that exists (DNS resolves) but that cannot be accessed (eg, ssh keys not set, or incorrectly set).
2. dvc status --remote <remote-name>

Expected

An error message indicating the source of the problem.
Parotting the error recieved from the ssh host would be OK.

Environment information

$ dvc doctor
DVC version: 2.31.0 (conda)
---------------------------------
Platform: Python 3.10.6 on Linux-3.10.0-1160.42.2.el7.x86_64-x86_64-with-glibc2.17
Subprojects:
        dvc_data = 0.22.0
        dvc_objects = 0.11.0
        dvc_render = 0.0.12
        dvc_task = 0.1.4
        dvclive = 0.12.1
        scmrepo = 0.1.2
Supports:
        gs (gcsfs = 2022.10.0),
        http (aiohttp = 3.8.3, aiohttp-retry = 2.8.3),
        https (aiohttp = 3.8.3, aiohttp-retry = 2.8.3),
        s3 (s3fs = 2022.10.0, boto3 = 1.24.59),
        ssh (sshfs = 2022.6.0)