Missing AWS::SecretsManager types

[corymhall]

Hello!

• Vote on this issue by adding a 👍 reaction
• If you want to implement this feature, comment to let us know (we'll work with you on design, scheduling, etc.)

Issue details

### Tasks
- [ ] AWS::SecretsManager::ResourcePolicy
- [ ] AWS::SecretsManager::RotationSchedule
- [ ] AWS::SecretsManager::SecretTargetAttachment

Affected area/feature