My 8yo loves the Ice Age 2 game.
We all love Wii sports resort - some of it is active, some is not.
I think the Ice Age game is the only story type game we have though
.
ETA: I've heard good things about the Animal Crossing - it's a Sims type thing I think...