Generally, no, ISPs provide DNS with generally the best locality of results. Sometimes it can happen that you get a shit resolution, but it's hard to identify

Generally, no, ISPs provide DNS with generally the best locality of results. Sometimes it can happen that you get a shit resolution, but it's hard to identify if DNS is the issue in home use since there are so many variables. However, some ISPs have truly terrible DNS service, for example at my father's house, the first request to any not terribly mainstream website (say outside top 1000 most visited or whatever) always misses the first query while the provider goes look it up on whatever upstream they use. In this case it was really a case of using a different DNS provider that doesn't prune the cache so much or that stalls while querying upstream.