I don't think the North Berwick Redan is in the same class of, say, Shinnecock's (of the ones you've mentioned which I've played), mainly because the back of the green complex is quite bland. You can safely go through the green and have a relatively straighforward chip back up the hill, which gives you much more room for error in terms of the line you take off of the tee to a back flag. As such, the green at Shinnecock really makes you use all of its contours (even in normal, non-2004 US Open conditions) to play a decent approach, sometimes just to keep the ball on the green, which to me is the point of the Redan. At North Berwick, the 15th feels more like a shot you simply hit at the flag, wherever it is on the green, with the wonderful slingshot effect often absent.
Patrick - isn't the 7th at Shinnecock more or less blind, at least in that the green is raised above you and you can't see all of the green or the bottom of the flagstick? Or perhaps my memory is failing...
Cheers,
Darren