Left for Dead 2 is quite awesome. I enjoyed Borderlands, and the rest of the list is also remarkable, but honestly, I really did love Brutal Legend. A lot.
It fulfilled most, if not all, of my expectations. Sure, I wanted it to be longer, and I would've enjoyed a more adventure-oriented game like a metal Zelda game, but I'm damn pleased I have a multiplayer game like that to play now. Great soundtrack, good story, amazing visuals, etc.
Now if we could just get some single player DLC...