Id say Mario Galaxy. That game all round is an eye catcher. Achieves amazing CGI graphics without relying on heavy hardware to do so. Its pure developer talent at its best.
Also Dead Space looks phenomenal. Seeing those ragged doll physics with a realistic dark artsyle at the time was also amazing.