There's a Wiki thread started back in 2019, but saw recent edits which might you might be interested in:
Also, you might want to mention the ACME client you're using, because e.g. Certbot only has a limited number of officially included DNS plugins. That said, the third party certbot-dns-multi DNS plugin uses the DNS integrations of the lego ACME client and it has a LOT of them. With other ACME clients YMMV, e.g. acme.sh also has a lot of DNS integrations, but I don't know about other ACME clients..
Personally I only have experience with running my own BIND and using certbot-dns-rfc2136 or free Cloudflare DNS (without their CDN services, just DNS) using certbot-dns-cloudflare. Which works quite nicely for me.
It's also possible to run your own instance of acme-dns by the way, which some users use as it also makes the dns-01 challenge a little bit safer compared to the ACME client having access to an entire DNS zone.