Barbra Streisand's cameo is #6 on E! 101 Most Unforgettable Moments.
Roseanne, Mike Myers, and Madonna were not told in advance that Barbra Streisand would appear on the Coffee Talk sketch, which means that they were genuinely surprised (as opposed to acting like they were) that she showed up.
The Red Hot Chili Peppers perform "Under the Bridge" for their second song. Guitarist John Frusciante messes up the opening chords, making lead singer Anthony Kiedis visibly angry.
Barbara Streisand's appearence on Coffee Talk is E!'s "101 Shocking Moments in Entertainment" #89.