fix: surface custom errors from http hooks

[JEETDESAI25]

HTTP hooks returning 4xx status codes now parse the response body and return custom error messages instead of hardcoded ones like "Invalid payload sent to hook".

This aligns HTTP hook error handling with the PostgreSQL hook dispatcher which already extracts custom errors via hookserrors.Check().

Fixes #2235.