Should Endless Ocean really count? The entire game was just looking at pretty things from what I have seen so I don't think it can be faulted for bad gameplay. Maybe there is more to the game then what I know.
Metroid Prime 3, Lair, Vanguard: Saga of Heroes, Crysis, and Halo 3 come to mind. Maybe Super Mario Galaxy, but with a second person the game becomes a lot more fun. After I finally beat it I will make my final judgment. There are more from earlier gens but I don't feel like listing them all.