At Using an AWS Secrets Manager VPC endpoint I am reading that AWS performs autorotation of passwords (e.g. for DocumentDB; see example CloudFormation configuration) using a network VPC endpoint. You configure a schedule and periodically (e.g. every 30 days) a lambda will access Secrets Manager via the VPC endpoint and update the password.
Apparently these VPC endpoints are "powered by AWS PrivateLink". I just looked at the pricing. I understand that they are charged every hour they are provisioned, and at (for example) USD$0.01 per hour, this would cost around over USD$7 per month—just for the lambda to be able to rotate the password once per month.
All these little costs here and there add up, and it seems wasteful to pay for something that is only used once a month.
Is there an alternative approach to have AWS automatically rotate a secret used for a database such as DocumentDB?