GoNintendo has an image of a list of details for some of the Nintendo Land minigames, giving us details on Yoshi's Fruit Cart, Captain Falcon's Twister Race, and Octopus Dance.
Octopus Dance is the greatest name ever given to a minigame. The description calls it a rhythm-based dance attraction, but I like Jonathan Holmes' description more:
"One game is about Yoshi putting fruit in a cart and the other is about the Octopus from Game and Watch dancing it's sweet little ass off until the player is left IN TEARS."
As you've gathered, Yoshi's Fruit Cart has our favorite dino putting fruit in a cart in a "brain-teasing attraction" that uses both the television and the GamePad.
Finally, Captain Falcon's Twister Race has you holding the GamePad, narrow end up, to guide a wind-up vehicle through a race.
Found this image. I have no idea why I love it so much.