First off, let's keep things as spoiler free as possible. If you post any spoilers please use the spoiler tag and make sure to post a warning, including posting the game's title.
For me it's...
Metal Gear Solid 4-A certain part near the ending.
Shadow of the Colossus-Obviously when killing the colossus I too felt an overwhelming sadness like I had never witnessed before.