Indeed I think that Modern Campaigns can offer the most exciting games - particularly in very few turns. Every move can be your downfall. I feel that it also requires the most brainpower per movement/turn, compared to the other Campaign series titles. Simply because of the fact that units are very fast and mobile, so there are always quite a lot of options where your opponent can be. And of course because of air support. The very asymmetrical setting also adds a lot of spice.
I planned to create a video AAR of my game against Kool Kat, but unfortunately, it just turned out to be too much work. There are so many things to consider and explain. And anyone not familiar with the rules would probably just be bored. Nevertheless, I attach a small pdf giving a few insights into my initial planning of that game.
Also check out my mod for Modern Campaigns (the terrain part of it is based on Jison's great mapmod!):
https://www.dropbox.com/sh/1djdocrg56uar...n54_a?dl=0