Support all --parameter-overrides file syntaxes already supported by AWS CLI V2

### Feature description

AWS CLI V2's `aws cloudformation deploy` supports [multiple JSON syntaxes](https://awscli.amazonaws.com/v2/documentation/api/latest/reference/cloudformation/deploy/index.html#supported-json-syntax) for the `--parameter-overrides` parameter when using a file URL, whereas AWS SAM CLI's `sam deploy` only supports one non-JSON syntax (at least as of `1.37.0`).

Both CLI should support the same syntaxes, so that automation can use the same logic on all stacks.

### Proposal

Support all JSON syntaxes listed on [the AWS CLI documentation page](https://awscli.amazonaws.com/v2/documentation/api/latest/reference/cloudformation/deploy/index.html#supported-json-syntax), and maybe deprecate the current one.