Game: Super Smash Bros. Melee
Console cameo: Nintendo's biggest and best
Melee is cram-jam-packed with Nintendo fan service. That's part of the reason why it was GameCube's biggest title. But nothing in-game compares to the trophy room's collection of every Nintendo system that matters. They even bothered to differentiate between Game Boys. Not sure about the gravity-defying N64 controller though.
Game: Super Smash Bros. Brawl
Console cameo: Game & Watch
Oh, did we say Melee was cram-jam-packed with Nintendo heritage? Brawl trumps it with ease, even without a special trophy room displaying the company's entire history. Not much in the way of console appearances, but there is this stage based on the ancient Game & Watch. See it in action here.
Game: Beautiful Katamari
Console cameo: Xbox 360
You'd think a series involving hundreds of household items lying about would have more console shout outs. Unless we missed something, only the newest game has a system in its sticky sights, and it's an Xbox 360. Well, tons of Xbox 360s. And controllers.
Game: Condemned: Criminal Origins
Console cameo: Xbox 360
Most of the Achievements in Condemned involve collecting rotting birds and finding as many blunt instruments of death as possible. Then there are a few completely out of place Xbox units plugged into malfunctioning TVs. Shouldn't it be the other way around?
Bonus nerddom: the 360s actually have Condemned faceplates