Opening: to many, a lot of good ones

Ending:
Shadow of the Colossus
Prince of Persia: The Two Thrones (perfectly ended the trilogy)