I can think of 3 games that use more than what a DVD can hold.
1) Resistance:Fall of Man
http://blogs.ign.com/Ted-Insomniac/2006/09/07/30283/
2) Ratchet and Clank Future: Tools of Destruction
http://www.gamegrep.com/news/5346-ratchet_clank_at_22_gigabytes/
3) Heavenly Sword
http://www.ps3fanboy.com/2007/08/14/heavenly-sword-has-10gb-of-sound-data-alone/