I only ever used the ISP's DNS until I had problems with the Vodafone ones. I use Quad9 because I prefer not to use Goggle, and to give some measure of protection from rogue websites, but I wouldn't say they are 'better' than any other. I think it's a bit like cars - no particular one is inherently better than another, but they all have different characteristics.