Personally for me, one of the most fun games I've ever played on console is the Ratchet and Clank series. Having mostly rid myself of the console market a while back, I've only played 1 through 3, but all of them were really good, to the point where I blew the dust off my PS2 and started playing it again recently. The story is mediocre but even the developers knew that, you can tell with how the game is portrayed and the story is told. All the way through it is light hearted humour while visually it's bright and colourfull and the weapons tend to be huge, sometimes overcompensatory on our little Lombax, with masive graphical effects. Since then I've not really played any console game that good tbh.
So yeah, go back to colour and big guns and fun and stuff. (Also, why was DUke Nukem Forever voted the besterest? It really wasn't, although admittedly I don't have a favourite, there's been some awesome ZP's like the Orange Box and Wii Sports Resort.)