Not really...game quality definitely is not guaranteed to increase as game size increases.
Right now there's simply no need to use that much space for a game..
...and unless the disk is filled with high definition pre-rendered cutscenes, no developer would be able to finish a 400gb game within the PS3's lifespan.