One of my faves is C G D G B B, which Thurston Moore developed.

Supposedly, he based it on a tuning Stephen Malkmus came up with, which was itself based on something Moore came up with previously. A great case of what goes around, comes around!

EDIT: Loads more of Sonic Youth’s tunings can be found here.