I'm not going to play a WW2 game if there isn't destruction. I'd like it to be at least a little realistic, like the Battlefield games are.
This is the next generation of video game consumers. Completely blinded by advertising campaigns, convinced that superfluous stuff like "realism", graphical fidelity, and destruction physics is the most important part of any game, and that just because a game is old that means it's no longer good.
1942 fits the description you laid out in the OP entirely except for the unnecessary graphical elitism. It has maps set in Iwo Jima, Stalingrad, Berlin, Omaha Beach, pretty much half the loving war. It has more vehicle variety than the recent games, from half-tracks and heavy tanks to battleships and level bombers. It has
completely functional warships that you can actually drive and fight with while people walk around on deck, a feature that has been totally blasted from the franchise for no discernable reason. It even has mod support that allowed people to recreate the loving Landkreuzer Ratte. But no, It's "old" and therefore bad. Well you can go forget yourself with the Schwerer Gustav for all I care because you're only hurting yourself by ignoring it. In fact, it being 12 years old is probably even
better for you because that means that no matter how stuffty the computer you're typing this on is, you can almost assuredly run it.