Yup ! my company is massively using DynProviders mostly as a means to "bundle" complicated resources together (e.g. we made a ProxyGateway for AWS API + Lambda together which involves ~ 10 resources)
We also use them to implement new services that have no Terraform counterpack (or a lacking implementation) : it's not trivial but it's definitely doable