I've played ~500 hours of SOW; given mainly on KS but never the less. Even with what HW:N is lacking I could not be paid to touch SOW again. You can just as easily TC and cheese cavalry into enemy guns with ease even at regimental scale cavalry; with squadron scale cavalry it makes it trivially easy. And it's not like its a problem only relegated to the regular RTS camera. It is more than easy enough to do in HITS. It is so easy to do that Kevin from KS eventually changed it so you could not give direct orders to cavalry units that are TC'd to prevent such abusive behavior. He has programmed some fairly realistic forced AI behavior regarding cavalry but even that is not enough to stop a determined player from TC taking your guns.
First of all, from my side there isnt any effort to make you play SoW, even if I got paid for, since you stated you made a certain decision for yourself. The fact that you didnt consider to try the mod and the setup we´re playing, doesnt change anything about it.
Secondly I did SoW for 634 h, much of the time on MP. But thats not the point. Some people gain more insight in 100 h than others in 1000 h.
After all, I disagree with what you alleged. Of course its basically possible that you loose all of your cannons. But thats simply not the case in nearly all of the MP games I had, no matter if larger numbers of Cav squadrons came around or whatever.
The common command for MP is the division. The division mostly has 1-2 batteries. Assuming the human player keeps up overview, does anticipate enemy movement and is skilled enough to use the AI stances properly, he mostly will be able to keep at least a good amount of the cannons.
Furthermore, as I stated in my previous post, if managing the AI-stances correctly, the AI in SoW does a much better job in terms of self protection than the one of the most recent version of HW could. Anyway, thats not relevant, if the human player cares for deployment, redeployment and emergency withdrawing according the principles I mentioned above. At divisional level the subordinated AI is more like a second level reassurance anyway.
Even at corps level, if some divisional AI acts independently, the batteries have a reasonable higher life expectancy than in this version of HW, where complete batteries often get extinguished within one single Cav raid. Most of us know, that it is absolutely normal, that cannons and gunners get lost, destroyed or killed in the chaos of napoleonic battles. And in SoW, apart from AI self protective redeployment, even if Cav squadrons infiltrate the lines, assuming the tactical basics are practiced decently, normally at least parts of the batteries can be remained.