There are only a handful of 2600 games I'd care to revisit: Yars' Revenge, Pitfall, and River Raid are the only ones that come to mind, in fact. Almost all the good games from that time were arcade games, and arcade ports sucked on the 2600. Most 2600 games are fun for 3 minutes.
And while not everything on the NES held up well, the Mario games, the Zeldas, Dragon Quest 1-4, and quite a few other NES games still hold up well.
So no, I would disagree. 2nd generation did not hold up well at all. The NES has games that are still awesome today.