Regardless of delivery method (keg, bottle, can), the beer SHOULD be poured into a good CLEAN glass.
Something tells me water doesn't actively BIND to nucleation sites, not permanently - the beer poured into the glass should theoretically mix with the water perfectly and cling to the same surfaces the water clung to previously.
Now, what I have heard is a good warm/hot water quick rinse is most effective at rinsing any remaining detergent/soap that is clinging to both nucleation sites and the glass walls in general.
That rinse, more than anything, should be helping to ensure the glass is truly clean, without adulterants clinging to the walls, so that the flavor profile is pure.
And I've never heard of a desire to reduce nucleation in beer glasses. Some of the best breweries are focusing on making specialty glasses with companies like Riedel so that nucleation is ideal for that individual beer profile; also, the glasses are shaped so that the ideal flavors and scents move about and hit the nose in the way they feel is best. (think: the many varieties of wine glasses).