Nope, it works all the way up the neck. If he plays a G shape, and the capo is on the second fret, you get an A .
And yes I'd say that being able to read up-side down chords with or without capo has got me through a few tricky moments and is a useful skill, more so for depping than being a band member.