Well, I dunno. I've only seen overuse of the controller in elebits, but that was done on purpose to tire the player out as a challenge. Maybe Zelda, but not sure on that one.
For me, I really wouldn't mind swinging a controller around. The problem I see with the PS3's motion sensitivity is that, besides racing games, if they have anything like their demo at E3, in which it was used to lift up a virtual rubber duck, it seems rather... awkward. And chances are that's gonna be any game of the PS3.