aws-rds: is it possible to implement addRotationSingleUser / addRotationMultiUser for ServerlessClusterFromSnapshot?

### Describe the feature

While we can add secret rotation by using `addRotationSingleUser`, `addRotationMultiUser` for `ServerlessCluster` custruct, these methods are not implemented in `ServerlessClusterFromSnapshot`. I still prefer to rotate user secrets when creating a serverless cluster from snapshot.

Are there any problems to add these methods for `ServerlessClusterFromSnapshot`?
I'll also appreciate any other recommended measures to achieve user rotation.

maybe related: https://github.com/aws/aws-cdk/issues/20434

### Use Case

Achieve user rotation for Aurora Serverless cluster created from a snapshot.

### Proposed Solution

_No response_

### Other Information

_No response_

### Acknowledgements

- [ ] I may be able to implement this feature request
- [ ] This feature might incur a breaking change

### CDK version used

2.92.0

### Environment details (OS name and version, etc.)

macOS Ventura

Start by comparing the existing addRotationSingleUser and addRotationMultiUser entry points on ServerlessCluster with ServerlessClusterFromSnapshot, then review the related issue 20434. Clarify how snapshot-created clusters should support user rotation and what behavior the new methods must guarantee before adding coverage for both rotation paths.

Written by the indexing model from the issue text.