If your looking for a decently fun game for a 2-4 player Gamecube party, then its definitely worth giving a look.
It does have a single player, but its nowhere near as fun as the multiplayer which is sure to get a room full of people yelling and screaming at each other (which any good MP game should do). There is some nice variety to the multiplayer with various levels all of which have their own unique traits to them (like one being very small, or another having a train track in it), they generally don't do a lot, but are just enough to give the game some decent variety over an extended playing session.