Just as you said CoD2 and Battlefield 2 are nice.
Other great/fun games IMO:
Condemned
The Outfit
Kameo
Rockstar Games Table Tennis (you don't think it is, but its real fun. Atleast vs a real person..
)
Ghost Recon Advanced Warfighter
Also I am really looking forward to Gears of War..