We were looking at it for a configuration management backend. So, yes, 500+ values, consumed by microservices.
I still say - the only real value even when compared to other AWS services is the rotation, which currently only really works with DBs (and then only if your service connects to the Secrets Manager directly, with every DB open).