DNS changes can take up to 48hrs to propagate worldwide. Central DNS servers such as those at Google will always update first.
The fact so many of us are having these issues (myself included) is a symptom of how DNS works.
Using your ISP's DNS is not a bad thing - for one leaving your settings on automatic stops you having to change settings every time a DNS server IP changes (rare but it happens). It also means your DNS traffic is initially handled within your own country making DNS response time faster for locally hosted addresses.
If you are using DHCP at home your router is providing your PC its DNS which is in turn gets it from the ISP.
So if you want everyone in the house to use Google DNS it's better to change the router DNS then use
ipconfig /flushdns at the command prompt at each PC as described previously.
NB
If your router uses 2 dns servers leave 1 pointing at your ISP and make a record of the one you change so you can switch it back later.
Edited by Vimeous, 15 July 2014 - 12:49 PM.