Honestly I think it depends where you are deploying to. I was previously using Netlify DNS for instance since most of my domains had static websites hosted on Netlify, this meant that they could manage quite a lot of records for me, I was also a fan of having CNAME-flattening which isn't available at domains.google (for reference I'm using the .dev TLD which is owned by the Google Registrar), but I've recently switched to using Google's name servers and even though I have to use a hard coded IP for the Netlify load balancer and I lost CNAME flattening I'm pretty the DNS requests are going MUCH faster (as in a few tens of milliseconds faster LOL). The reason I'm using Google's name server is because Netlify DNS doesn't support DNSSEC which for me is simply absurd in 2023.

Anyways, if you don't have a specific reason to pick any specific nameserver go with the easiest one or if you want to have the most features and portability go with Cloudflare.