Recently, the only game that's blown me away with the opening (Pre-title card I consider the opening) would be Mass Effect 2. It was incredibly well done, it seems a great opening is something most games don't bother with lately.
For opening cinematics...Hard to beat Blizzard, they always did know how to sock you in the gut before throwing the title card in your face. I was always partial to the Diablo 2 opener myself. "What could I do? I followed him. And from that day, we traveled together. To the east, always into the east."