In my experience, Napoleon's super accurate artillery artillerie a'pied (IIRC) is an absolute beast with or without the X2 damage mod. This has lead me to think that accuracy is way more important than the power. I don't have the faintest idea about soldiers standing up after getting shot though.