so let me get this straight.. you could use #6 copper for your city water pipe connection, and your ground rods??? even for lets say a 300amp service??
To the rod yes, to the water line it would be sized directly from table 250.66.
Put a 4000 amp service in a field and you will only need a 6 AWG CU to one or two ground rods.