Richer errors in Dapr for the Secrets API.

Original #7484

Scope of work
Choose 5-10 errors in the Secrets API to enrich. Ideally, cover as many errors as possible from the API.
Follow the steps outlined in this README for each error being updated
Definition of done

• Update 5-10 errors in the Secrets API
• Update the unit tests, if necessary
• Write integration tests to cover each updated errors

Keep in mind
Unless a major version is being released and there is a solid reason for introducing backwards incompatibility, we can't change the API, meaning the HTTP and gRPC status codes, and the error codes must stay the same. An exception to this is the gRPC StatusCode.UNKNOWN which should be converted to a specific status.

See the kit errors pkg README for another usage example. For each error being updated, you can use the following helper functions to add error details, see the kit errors pkg for more details:

• WithHelpLink()
• WithHelp()
• WithErrorInfo() - Required
• WithFieldViolation()
• WithDetails()

Reference PRs
Existing error standardization for:

#7257
#7322