in Walkure when Brunnhilde tells Sieglinde that she is pregnant with the best hero ever, Sieglinde replies "Magnificent Victory!" with a really phenomenal short piece of melody... it's that same line that is repeated at the end of Gotterdammerung when valhalla is burning. magnificent victory
I think that's the leitmotif of Redemption. Definitely my favourite moment and leitmotif in the Ring Cycle also.
I love all of Rheingold....but have now got lessened enthusiasm for Der Walkure and Siegfried...but my favourite moments come from Gotterdamerung, especially the Trio that ends Act 3, when Gunther, Hagen and Brunnhilde plot to kill Siegried. That is thrilling....
Then, the whole of the Prologue...with the 3 Norns fiddling-about with their rope and then the ecstatic Brunnhilde and Siegfried after their night of Bliss...before Sigs is off down the Rhine.