Well, I am still very young so doing that kind of stuff pleases me. I guess it would be good if Nintendo's next Wii product allowed the user to opt how they would like to play the game, as in; the Wii would come with a motion-sensor controller as well as a regular controller and all games made for that console would be playable on both controllers. I think that would take a long time to work on, though, so it probably wouldn't really get implemented unless Nintendo see that as the right thing to do sometime.
RPGs probably will just stick to controller-based consoles since they involve a lot of moving and many people wouldn't want to bother. Even though some would find it enjoyable, some isn't a enough to sell millions, unfortunately.
In general, however, I would like to see more precise motion-sensor games, would make it a lot more fun and challenging.