You may find many of the Activision titles still hold up. River Raid, Megamania, Seaquest, Frostbite. There's a lot of fun to still be had in those games, especially if you're competing head-to-head.

But for my money the most fun you can have on an Atari 2600 today is 4-player Warlords with well-maintained paddles.