Validate AWSApplicationAutoscaling available in region, and node type

[nartz]

Is this feature request related to a new rule or cfn-lint capabilities?

new rules

Describe the feature you'd like to request

when validating resources in a region, e.g. us-gov-west-1, trying to apply AWSApplicationAutoscaling to a redis 7 cluster results in AccessDeniedException because it is not availble in the region; however, this is not caught using -r us-gov-west-1.

Similarly, only certain node types are supported for redis autoscaling; cfn-lint should validate the specific node types supported by redis autoscaling

Describe the solution you'd like

cfn-lint should be able to properly verify whether redis autoscaling is available in a region from the region specification file

Additional context

No response

Is this something that you'd be interested in working on?

• 👋 I may be able to implement this feature request

Would this feature include a breaking change?

• ⚠️ This feature might incur a breaking change

[ArjunMenon-bit]

ElastiCache for Redis Auto Scaling is limited to the following:

Redis (cluster mode enabled) clusters running Redis engine version 6.0 onwards

Instance type families - R5, R6g, M5, M6g

Instance sizes - Large, XLarge, 2XLarge

Auto Scaling in ElastiCache for Redis is not supported for clusters running in Global datastores, Outposts or Local Zones.

AWS Auto Scaling for ElastiCache for Redis is not available in the following regions: China (Beijing), China (Ningxia), AWS GovCloud (US-West) and AWS GovCloud (US-East).

@kddejong happy to contribute to this issue if you think this would be a good starting point :)