The most memorable cutscene in the game for me was the flashback of Day 12 on Lightning's birthday:

YouTube - SplitPlaythru: Final Fantasy XIII US (050) Worst birthday ever