Add useful RPC error messages for HTTP error statuses

[Wodann]

Definition of Done Improve RPC error information by achieving one of the following results, in order of preference:

1. Upgrade HttpStatus error to JsonRpcError when possible by parsing the HTTP response body
2. Returning the HTTP response body along with the status error

This PR (https://github.com/NomicFoundation/hardhat/pull/3913) fixed several failing tests due to us starting to report HTTP error status, but illustrates that the verbosity of the error messages was significantly decreased. Ideally, we're able to still get the same quality of error messages, while also detecting HTTP error statuses.