There were plenty of games that were great in that generation of consoles.
Besides those already mentioned, looking at what I own, there's:
Yakuza 4
The Ratchet and Clank games (Minus All 4 One, or whatever)
Dragon's Dogma
Muramasa
Dishonored
Darksiders
Nier
Xenoblade Chronicles
Metal Gear Solid 4
I'm sure there are others that others would put on their list, as well.
I don't think it was as good as the PS2 or the DS, but those two dominated the market, so it's no wonder.