undersizing a board makes it easier to throw around. it makes a board feel more flexible, easier to butter, and just generally what a park rat would do.
oversizing a board makes it more stable at high speeds and landing big jumps. it also makes it float better in powder. best bet for a freeride type of rider.
obviously people don't actually alter the physical size of the board. they just get a bigger or smaller board for their weight.