MGS4 uses motion sensing for aiming grenades, and that's about all I can remember from it.

It does a couple of pretty surprising things with the rumble though, if you play your cards right. (One early example: if you beat the first boss without killing it, when Snake checks its pulse you can feel it in the controller. If you do kill it: no pulse.)