Super Mario Galaxy lets 2 people play at once.
It was announced a while ago and was playable at E3.
Player 2 takes control of the camera guy (Lakitu again?) and throws star things at enemies. Think Floyd from Jet Force Gemini (which came in handy for that final boss ooooh yea).