Gilrandir, it sounds like you would benefit from reading Frogbeastegg's guide to MTW:
https://forums.totalwar.org/vb/showt...eval-Total-War
For example, that explains what valor does - point for point, it's better than morale, because not only does one valour give two morale, it also gives one attack and one defence. However, comparing valour and morale seems something of a false dichotomy as - at least in SP - you can't choose your valor. It's just essentially just experience and more experienced troops are better than less. You choose your units and their morale stat is something to consider, along with the "harder" stats of attack, armor, defence etc.
To see morale stats of individual units, you could look at frogbeastegg's unit guide:
https://forums.totalwar.org/vb/showt...War-Unit-Guide
However, I don't recall being that concerned about morale when picking troops in MTW SP as typically you choose the best units for their role (rock-paper-scissors) and morale either doesn't differ among the possible picks or is higher for the better equipped units (feudal sergeants to chivalric sergeants is one salient exception to this; I suspect the lower morale of the upgraded unit is a balancing issue because chain armor is just so good).
However, when using troops, I am mindful about their morale. I would be careful some fragile units like woodsmen (morale -2) and line units that were suprisingly poor in morale such as Chivalric sergeants, Byzantine infantry etc (morale 0). They need to be kept out of missile fire if possible, supported and ideally near a general. Conversely, some high morale units like ghazis are like psychotic energiser bunnies and can be left to do or die, usually dying but to glorious effect.
Bookmarks