I've found this generation to be in my top three in regard to fun, right up there with N64/PS1 and SNES/Genesis.
There's a difference between a game that has good cinematography and graphics just for the sake of them and those that use them to actually enhance the game. Resident Evil 5's fantasticd graphics and well-paced cutscenes help to immerse you in the game, making it more fun. The enemy AI is only poor because it would be completely unfair to have fifty incredibly-intelligent guys just run at you and endlessly stab you.
I think it's great that we're at a point in gaming where something fast-paced and irreverant like Brawl or Mario Kart can coexist nicely with something like Metal Gear Solid. I can appreciate and have fun with almost any genre of game, as long as it's done well. There's no one way to have a good game. Indigo Prophecy is a fantastic game, as are Halo, Zelda, Breakdown (seriously, someone needs to play it), Riddick, Splinter Cell, Metroid, Castlevania, etc. All of these genres have a place--as long as they do it modestly.