Ok well here's what I can think of right now, can probably add more later.
Wii Sports Resort
Trauma Center Second Opinion
Trauma Center New Blood
The Godfather Blackhand Edition
Zack & Wiki
Metroid Prime Trilogy
Pro Evolution Soccer 2008/2009/2010
Tiger Woods PGA Tour 2010
Grand Slam Tennis
Star Wars The Force Unleashed
It's worth noting that a lot of the games that have the best controls on the Wii don't actually use very much in the way of motion controls. The use of the IR pointer is in fact what generally sets the Wii games apart from the HD rivals for me. This seems to have gone straight over both Microsoft's and Sony's (to a lesser extent) heads, as they are basing their new controls mainly around having motions.