Yeah I remember Close Combat. I liked Steel Panthers WaW with the campaign layers (Desert Fox 41, The Lost Battles) included and then Combat Mission CMBB /CMAK a lot more.
After reading your post I have assumed you have not tried CMBB or CMAK (CMx1). I am thinking they would be what you are looking for, for now. Hundreds of scenario's and campaign's are available at the Scenario Depot II. Also CMAK can be modded to CMETO for Western Theater battles if you like that theater. There are still online opponents available at sites like WeBob and such. As well RobO created a excel spreadsheet campaign layer for both CMBB and CMAK, which is excellent.
I remember feeling the same way as you did with Close Combat when I played my first Combat Mission scenario with CMBB back in 2002. It was about Wittmann and his Stug (Wittmann in the East or Wittmann's Iron Cross), the fog (when using WinXP), the rain, the Eastern Front.... I was hooked big time and I am still spinning those titles when I have the Ost Front or NA itch.
Now back to the present. This community will eventually have lots of scenario's and campaigns made for CMx2 engine, CMBN already has quite a collection. CMFI will eventually as well and so on...