Laptopmag has done a very good job at the Honeycomb event. Here are some videos of interesting apps. Most impressive!

http://www.youtube.com/watch?v=5oZdH1U_IQc
This video shows the fragments in much more detail. The fragments can not only be vertical panes, but also horizontal/grid like layouts. A good one to watch!

http://www.youtube.com/watch?v=WRpspThKJfI
http://www.youtube.com/watch?v=yXj1_msY0NI
http://www.youtube.com/watch?v=YeoOJfC4HJM
http://www.youtube.com/watch?v=FzEgp-wHWIs
http://www.youtube.com/watch?v=ZGFeDSbpf0A

IMNSHO, Honeycomb is a major step forward for Android. The UI seems much more cohesive than previous versions, but it's easy to see that they are still incredibly flexible in addition to this. They are also very smooth.