I think these strategies are aimed more at graphics and fun than efficiency. This is a game, so fun is the object, but they wont work beyond warlord. Once you get to higher levels you don't have the luxury of drastically outnumbering your opponent or having huge tech leads. You have to win wars against armies twice your size and equally or more advanced. Sadly it is all a matter of statistics. There are numerous threads in here that explain them far better than I could. I recomend going to the war academy.
A few pointers.
1. Paratroopers are a joke. They cost 100 shields and have an A/D/M of 6/8/1. In the same period, Mech Infantry costs 110 shields and has an A/D/M of 12/18/2. Modern Armor costs 120 shields and as an A/D/M of 24/16/3. It doesn't take calculus to see all you should build in the modern error is MA. (granted Mech Infantry are marginally cheaper and better at defense but the MA's huge advantage in movement and offense makes it the only time in civ that one unit is all you need) According to the combat calculator (
http://www.columbia.edu/~sdc2002/civulator.html) If MA attacks a fortified Paratrooper it will win 92% of the time. If a Paratrooper attacks a fortified modern Armor it will lose 96% of the time. Even if the paratrooper is fortified on a mountain MA will win 65%. Correct me if I'm wrong, but a paratrooper's drop radius is only like 4 squares. That means the modern armor could get to wherever you drop the paratrooper in two turns (even if the drop radius is 6 squares).
2. Use defensive units for defense, offensive units for offense.
In the very first example Lynx posted, he referenced attacking riflemen with riflemen. Riflemen are defensive units. They should not be used to attack other defensive units. I realize you probably know that Lynx but the reference could confuse others. A rifleman attacking a fortified rifleman of the same strength will lose 85% of the time. I would only use them to finish off a wounded offensive unit (i.e longbowman or cavalry). I agree with the fact that Calvary are also not ideal against rifleman. A veteran cavalry only beats a fortified veteran rifleman 34% of the time. Calvary are only effective in large numbers. Half will retreat before dying so you can use them another day.
3. Use artillery to get the odds in your favor
The secret of even warfare (cavalry vs rifleman or tank vs infantry) is artillery. I know it is slow and sometimes boring, but if you can knock two hitpoints off of a fortified veteran rifleman, a veteran cavalry will now win 70% of the time (more than twice as often.) The case is even greater when attacking a city. a city adds something like 50% to the defender. So a veteran cavalry will only win 20% vs a fortified veteran rifleman in a city. But if artillery knocks off two hitpoints the cavalry wins 57%, and 70% of the time if 3 points are knocked off. If the artillery kills enough citizens to knock the city back to town status, Calvary wins 70% vs a 2 hit point rifleman and over 80% vs a 1 hit point rifleman. You need at least 20 pieces of artillery to do this, 50 to 80 works much better. (btw all these odds assume the defender is not on a hill, mountain or acrosss a river)
Artillery is even more effective as defense, especially when combined with railroads. Initiate your war, maybe take one or two cities and then sit back and wait for the counter assault. The AI will throw everything it has into your territory. Make sure your artillery is on your RR and zip it to where you need it to cut down all the AI's troops to 1 or two hit points. Send your cavalry/MA out to wipe out the entire wounded force (veteran cavalry will beat a 1 hitpoint unfortified tank 80% of the time) And riflemen are great against 1 hitpoint cavalry or bowmen. In two turns you will wipe out the majority of the AI's military while sustaining almost no losses. Then march in and do as you please. I find this is less time consuming than bringing the artillery into enemy territory at 1 square per turn. After this you will have the number advantages even on medium level games so you don't need artillery necessarily. I would only use artillery for cities and metropolis once I wiped out the AI's military. Hell you could even use paratroopers at this point.
I know this works up to monarch. AI might get smarter above there.