It's an incredibly beautiful one, too, and contains wonderful singing from every member of the band, which could be such a hokey idea, but it's done with great effect here.
It's small and quiet, but still has it's grip on you. At the end, it fades into a piano coda, tying the album up with a musical nod to the first track. It's little bits like that that you really don't see much of these days, especially in this anti-album era. On a big double album like Mellon Collie, there needs to be cohesion, otherwise the whole thing is too jumbled and rambling. The piano at the end of Farewell & Goodnight is the perfect thing to package it all up with string.
It's also the only fade out I'll ever tolerate, because it isn't truly a fade out. It's only getting quieter because you're falling asleep.