I'm probably beating a dead horse at this point and many of these games have probably been mentioned several times over in this topic, but just in case:
For single player:
Mario Galaxy 2
Metroid Prime 3/Trilogy
Monster Hunter Tri
Little King's Story
Zack and Wiki
Zelda Twilight Princes
Red Steel 2 (uses the motion plus surprisingly well)
For multi:
Mario Kart Wii
Smash Bros Brawl
Wii Sports Resort
Warioware
Both:
NSMB Wii
DKCR
Rhythm Heaven Fever
Kirby Return to Dream Land