As I have not solved this in earlier versions, I add my parenthetical snivelling to my post. :-)
To start, text within cells align based on the content type. Numbers and with decimals to the right; sometimes text is centered, sometimes for artistic reasons right, and often text is left. InDesign does not seem to go all the way with our control over predictable cells and their paragraph style alignment. Even in its basic form, you have a right colum / left column choice to apply styles within your columns — and of course, it doesnt come close to meeting the needs of information designers when Table Styles are there to offer just that.
Additionally, there is the Footer & Header. This is a definitive extra step to declare the top line a Footer, or am I wrong and have not exhausted this website and Youtube?
Because I cannot attach a screenshot, I'll do my best to narrate visually….
My Footer (diff background color) has cells with a mixed alignment of text.
My Body Rows (alternating fills, skipping the header and first row) has cells with a mixed alignment of text.
My point: Is there a definitive workflow of creating para styles / cell styles and then the Table style to get very specific mixed alignments to be automated?