I have found setting custom DNS breaks many coffeeshop and airport wifi hotspots, and so I don't recommend it for the general user. I can't imagine there are that many people using Google's DNS or OpenDNS.
You could change the DNS settings on your home router, so when your machines pull the DHCP data you will receive the modified DNS. But when out and about, everything will work as expected.
