UMDs were up to 1.7GB, most major games are going to be around 1 - 1.6 GB. There's a lot of variation though and a simple game like Final Fantasy 1 is 188MB while Chinatown Wars is 862MB.
But there's also some leeway because images can be compressed, and people used to distribute ripkits which...