Will go out on a limb here and say that after listening to the White Album for about 35 years now, I see a whole new 'sound picture' within 'side four' of the White Album regarding Revolution 9. I have a new appreciation for it!
Many have commented about the juxtaposition of the sequence of Revolution 9 right into Good Night. To take this further, as a youngster I found the grouping of Cry Baby Cry >> Can You Take Me Back? >> Revolution 9 >> Good Night to be quite dramatic as sort of a "suite" of songs. At times, downright scary. With headphones on, I would have jumped a mile if someone snuck up on me and said 'boo' during the moments of quietness as "Brother, can you take me back?" trails off into the brief spoken word prior to the piano intro to Revolution 9 (all that reverb on Paul's voice like he's walking through an empty cathedral at night with the lights out). I doubt that this was intended as such although sometimes I wonder.
I have read that John and Paul labored intensively over the running order of the album. I have released CD's myself and understand how crucial (but often unnoticed by the general public) the running order can be. Can't imagine what it would've been like to arrange the order of 30 songs. That is one of the factors that makes this album such a winner!