Are there post-ToT version historical scenarios like Red Front, Operation Market Garden, Lord of the Rings, or Napoleon? I don't mean just mods, but realistic scenarios on accurate maps with accurate orders of battle and realistic results. I'd like to hear from folks that have delved into more recent versions of the game, if they care to respond. Thank you.
techumseh, I think there will not be many answers in this thread from modders, that have done mods/scenarios outside Civ 2, as most of the newer modders - and it seems Firaxis, too - have forgotten to be aware of the advantages of versions of the civ series coming before Civ 4. Many posts show, that their civ horizone starts with Civ 4, where my Civ world ends, as I really don´t like those 3D graphics and the table top presentation, that in my eyes is not the best solution for a strategy game.
The 'post-ToT historical' C3C scenario
SOE (Storm over Europe) until now in my eyes is the best scenario about WW2 in Europe of the complete civ series, especially when considering OOBs. The scenario holds more than 1,000 different unit types, 512 cities and
here you can read more about the OOB.
It also holds some Civ 2 graphics for minor cities.

SOE at CFC only has about 70,000 views as we had a special site for it (the SOC site) and with the closing of the SOC site some years ago this scenario is not available to the public since a longer time.
Civ 2 was pure genius and introduced the - in my eyes - most important feature of the civ series: Modding
When Civ 3 came up, I had a long fight with myself, if I should continue only modding Civ 2 ToT, or if I should mod Civ 3 - at the end I decided to do both, but the focus was on Civ 3, as I really like these nice animated units coming with Civ 3. The other side of the medal - and a heavy setback for me - was the missing of the Civ 2 events and I also didn´t like the cartoonish style, that was getting more and more worse with every following version of the Civ series, changing the serious historical direction of the game in Civ 2 to a kind of a 'Mickey Mouse' game. Here you can read, what I have posted about that topic more than 10 years ago:
https://forums.civfanatics.com/threads/alarming-silence-of-firaxis.246561/page-12#post-6082150
This said, until now I´m missing the events coming with Civ 2, that make creating historical scenarios so much easier. Per example in the C3C SOE scenario I had to transform the techtree into a calendar and to set 'immobile base units' at some special locations, where they were able to upgrade to the units that are needed later in the scenario, when they in reality did appear. Another workaround for missing events in Civ 3 was the option introduced with C3C, that buildings can produce units in adjustable intervalls with adjustable perequisites. On the other hand even some smaller features of Civ 2, like Civ 2 helicopters, a bonus for units attacking citywalls, barbarians that can hold cities, caravans and units for spies and diplomats, are unfortunately missing in Civ 3.
I´m really exited about the cornucopia of possibilities coming by the TheNamelessOne and TOTPP. On the other hand I would really appreciate, if there would be the possibility for animated units showing a defense animation and an 'enmovement' function for different soundfiles when these units are moving.
As a version of Civ 3 with events will never come, I hope there will come a time for completly animated units (even defense animations !) with Civ 2 ToT. I have not forgotten Prof. Garfield´s great thread '[TOTPP] Get Started With Lua Events'

and will come back to it, when RL allows me to do so.