The moment I killed the Archfiend in Ninja Gaiden 2 on Master Ninja difficulty has to be at the top for me. :) It's one of the hardest games out there to finish on its own, let alone on the highest difficulty.
Aside from that, the ending of Mass Effect 2 was a highlight, after finishing the...