Changing your DNS won't improve ping times in games, so no, it won't work. It may make your browser feel snappier, if your current DNS server is slow. However, don't pay for a DNS service. Google (8.8.8.8 and 8.8.4.4) and Cloudlfare (1.1.1.1 and 1.0.0.1) have free DNS servers and they are very fast.