I haven't finished many games, but some of the more recent ones that sticks in my mind are New Earth from Sin & Punishment and the Earth-Killing Meteors from the 2 Ouendan games.