I haven't played 3 yet, but I do have CoD 2. It's a great game, both off and online. But it's better online, especially if you have friends that play it
There's plenty of people still playing CoD 2 so you should easily find some matches, and there's various game modes to keep you entertained. There's probably some good mods out there that I haven't encountered yet as well.