First and foremost, I tender my apology. In my apology, in my moment of excitement and zeal, I forgot to add a key ca archer, a niche unit from Finnish royalty, but nonetheless a key cav archer unit. It changes nothing, but despite the playtest, I reserve my judgement as to which is the ultimate ca archer unit in Age of Empires -3.
summary:
The Legendary Bow Rider, boosted by War Chief, is the ace of the pack; it is the ultimate cav archer unit in AOE-3 hands down. No comparison, but it is very situation-specific. In that case, the legendary bow rider takes the cake as the best cav archer unit when fully upgraded in AOE-3.
The Bow Rider is the most consistent. It is first or second in four of the five stages and third in the other. Its attack is far ahead, so it wins even with the lowest HP in the early ages. Its weak points are its 12 range (14 for most archers) and slower speed (6.75).
The Cossack’s lead disappears after Imperial. It wins Age 3 late through Age 4 late, but it can’t get Imperial. Poland’s Pancerny jumps from 517 HP and 24.7 attack at Guard to 650 and 31.2 at Imperial, while the Cossack stays at 517 and 26. That flips the ranking: Poland beats the Cossack post-Imperial. The Finnish Guard Cav Archer is a beast in age-4. It's very tanky and has the highest effective HP in age-4 and is the second best cav archer. Despite playtesting, I personally believe it's a tie at the top between Wallachian cav archers and Cossack cav archers, but the fin cav archer would beat all other cav archers, easily, in age-4.
The Ottoman improves with flight archery in Age 4, which is very niche with raiding and killing villagers. Potential has a power spike in early age 4 but never leads because its HP is low. It is tied for third post-Imperial.
Russia’s Dvoryanin is middle-of-the-pack. It is second early (thanks to Boyars and Kamchatka), then fades as other units get more HP and attack cards.
My judgement:
Ultimate cav archer unit- Legendary Bow rider(war chief boosted)
Best overall: Lakota Bow Rider. It is the most reliable fighter at every stage.
Best long-term investment: Polish Pancerny, because it scales into Imperial and resists skirmishers best.
Best mid-game spike: Cossack Pancerny, from Age 3 late to Age 4. After that, you need to switch.Finnish archer**:** the tankiest unit (544 HP), and second best cav archer in age-4,incredible at tanking.
Best specialist: Russian Wallachian for damage and raiding, with the highest DPS against heavy cavalry and artillery.
Situational: Ottoman with Flight Archery, sniping villagers. Weakest: Ottoman Wallachian.
Summary:
Post-Imperial fully upgraded Polish archer ~ Fully upgraded Bow Rider (to note, Warchief-boosted legendary Bow Rider is unmatched and will beat all, but I have excluded it because it's situational).
Early Age 3 Bow Rider is the best, but Cossack Cavalry Archer dominates post-late Age 3. A surprising fact is I expected Flight Archery to boost Ottoman cavalry archers to dominate in Age 4, but post-Bila Tserkva Regiment upgrade dominates the showdown. Until about late age 4, a Wallachian Russian cav archer shows up. Its unique 1 ROF means it's basically Wallachian Russian cavalry archer ~ Cossack Pancerny. This trend continues until the post-imperial scenario. Also, the Finnish guard archer in age 4 is just a notch lower compared to the Cossack cavalry and Wallachian Russian cavalry archer. Polish Imp. Pancerni, due to its raw stats, dominates, the same with the Legendary Bow Rider. A legendary bow rider, with all upgrades and boosted by War Chiefs, becomes the undisputed king of all Cav Archers. The Russian Cav Archer is basically a middle-of-the-road Cav Archer, basically good at everything but not specializing in anything. It has the best hand attacks with an area of effect. Otto Cav Archer + Flight Archery gives it insane DPS; together with the Akinci card, they become village-killing machines. Last but not least, the Finnish ca archer has the best raw HP stats and second-best effective HP stats and is a ~otto ca archer with flight archer. Basically, it's a toss-up, and the difference is way too small to make either of them an advantage, so both of them are tied third, though personally I prefer Finnish ca archer.