Battlefield: Modern Combat... just like it's 1942 predecessor, but set in modern day wih current weapons. You can ride any vehicle and pick up any weapon. Mostly a network combat game. It'll come out with a limited one player action but it's meant for training.
Full Spectrum Warrior: Team based combat. Awesome gameplay (so far, from the 20 minutes I played it.) You control two groups that help each other gain an objective. The AI is smart but can't part from each other. The enemy AI is smart too. It doesn't just stand there shooting at you. It runs and hides and wants to live. If you're good you can catch them while they are moving positions...
Medal Of Honor: Pacific Assault
Here's something I liked... Call Of Duty: United Offensive Expansion Pack
The scenery while they are in the Bombers is beautiful, I can't say it's realistic, cuz I've never been in a WW2 bomber while being attacked by German forces, but the scenery and fight seem real enough. These pictures suck, because you can't see what I'm talking about.