I know there are a few games that support Single-Cart Multiplayer.

The ones I know of for sure...

Advance Wars
Puyo Pop
Mario Kart
Bomberman Tournament
Yoshi's Island
Super Mario
Sonic Advance
Sonic Advance 2
Sonic Pinball
Columns Crown
Rampage Puzzle Attack
Chuchu Rocket