Apart from Zelda, I'd have to say my second favorite would be the Uncharted franchise on the PS3. It has a great storyline, graphics, and multiplayer community.
And if I had to choose a runner up, it would definitely be the main Valve games (Portal, Half-Life, TF2)