The only commentary I recall from recent years was a southbound approach into EWR. "Passengers on the left may wish to look out of the window, for a wonderful view of the Manhatten skyline highlighted by the setting sun. For passengers on the right... welcome to Newark, New Jersey."
I'm with the majority in general - prefer to work, sleep or watch a movie inflight, and I'm a bit annoyed by anything non-essential that interrupts me. If anything's changed in the last 20 years, it's that many people fly more frequently so the "ooh" factor is diminished, and skies are busier so there's less time for commentary from the flight deck.
What *really* worries me is the next few years. "Hey mom, I'm on the plane, I can see our house, wooohoo." How much is a learjet again?