That's always the point of the demo videos, they find specific scenarios where it will actually work to beneficial effect, but I'm betting most people will get very differing results.
It would be nice if Adobe could spend half the time developing UI improvements and adding settings and preferences to bring the software up to this decade's standard as they do producing these these gimmick features. It took them how many years just to add docking windows? Yet if I relied on Photoshop (which I don't because Paintshop Pro is superior in most ways that count) I would be constantly digging through sub menus to reach my most accessed tools, and a mess of windows to adjust their settings. It's amazing to me how I can operate PSP with nothing but my Intuos3 hotkeys, yet Photoshop requires no less than being tethered to a keyboard and memorizing 200 shortcuts to operate.
Right now my major gripes with CS5 is they somehow botched the smudge tool--hopefully a symptom of the pre release but who knows. Other tools like the gradient fill are still in desperate need of an overhaul. They still improved very little outside of the new gimmicks, like consolidating resource files to My Documents so I don't have to dig through subdirectories for relevant files. And they divided the brushes menu into two, so now I could enjoy twice the hassle of frequently adjusting brush settings.
Also their attempts to encroach upon Corel's Painter seems lackluster and insulting--like we're supposed to wait for three more full versions before they'll really get around to it.