I think that Heavy Rain, surprisingly, will be the flagship of motion controls and how they can be utilized to their maximum effect.
If you click play on the clip I posted (it'll automatically start where I want it to), you'll see how fucking powerful motion control can be. Without motion control, Heavy Rain will probably be very very empty. I mean, just imagine how engrossed you are into that scene. Rapidly pressing the button to imitate the shaking of the hand and the beating of your heart. Squeezing R1 and L1 like you would with the axe, and then finally and best of all, bringing it down WITH the character via the Sixaxis.
That's is infinetly more satisfying that simply pressing Choice A or B.