Mario Kart Wii is fun for family.
In the same family game type some Wiiware games rock. Try Tetris Party and Bomberman Blast.
For individual games, depends on what you like. I had lots of fun with Boom Blox but you may not like it's simple gameplay mechanics. Although it kept me playing for hours. If you like violent games try No More Heroes, this is not for family play though.
What kind of games do you usually like? From your response about Zelda and Paper Mario I'm not sure if you will like Mario Galaxy, but it is one of the best Wii games in graphics, gameplay and fun. I consider Ocarina of Time to be the best Zelda game so I find it odd that Zelda died for you after the Snes. If you haven't played that getting it on the VC is a good option.