The smallest one is 4 MB (Turok: Rage Wars) and the biggest one is around 64 MB (Resident Evil 2). Of course only a few games are that big (Conker's Bad Fur Day, Pokémon Stadium 1 and 2). Most games are in the range between 8 MB and 32 MB.
These sizes are uncompressed.