Provide more details on "Could not find a value associated with JSONKey in SecretString" related failures

### Name of the resource

Other

### Resource name

_No response_

### Description

If you have a stack that uses [`secretsmanager` dynamic references](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/dynamic-references.html#dynamic-references-secretsmanager), you can get the following error message `Could not find a value associated with JSONKey in SecretString` while updating the stack.

CloudFormation does not clarify which SecretString(s) are causing the issue. This becomes difficult to troubleshoot if you have hundreds of inline dynamic references in one stack.

Ideally, CloudFormation should at least tell us which secret is causing the failure.

### Other Details

_No response_

Start with the issue description and its AWS CloudFormation dynamic references documentation link, focusing on secretsmanager references that use SecretString and JSONKey. The requested outcome is an error that identifies which secret causes the failure during stack updates; no repository files or tests are named.

Written by the indexing model from the issue text.