Starcraft, of course such games are compressed except for streaming lossless 7.1 audio. Like a Motorstorm dev pointed out the Cell is well suited to decompress data faster than the extra time needed to read uncompressed data from disc, so this makes sense.
Uncharted provides technically amazing graphics, IMO unlike anything seen on the 360 so far. Yet Naughty Dog stated they are only scratching the surface of what's technically possible with future SPE enhanced game engines. Texture streaming like in Ratchet and UT3 will become more important to really push the PS3 to new levels. Insomniac states they know what to do to adapt their legacy engine to push the PS3 much further even, Epic states their engine is seeing fast improvements as time goes on and they think future 1080p UT3 engine based games is feasible on the PS3. The extra disc space will come in handy for streaming high quality textures.
I think Gran Turismo 5 and White Engine (built from the ground up for the PS3) based games will provide a good indication of what's possible to achieve.