Aye. Like all design paradigms, there are places where they can be useful or can be used to achieve a certain feel.
I actually hate “choose from a menu combat” but have thought of a few cases where it would make sense - for example a Legend of Galactic Heroes style space warfare game based on hyper-realistic combat between massive fleets of 20,000+ ships each, which according to lore, line up in nice neat firing lines and shoot at each other for 12+ hours until one side has won via attrition. There is no way to simulate that in real time and be fun, and the ranges at which combat happens in deep space means that there is basically literally no room for maneuvering once the battle has began…
IDK. I skipped horse archers in my latest dark elves playthrough of total war warhammer 3, because they are so trash. No shields + large targets means they die really easy to missile fire, And since you can’t use a longbow on horseback they lack the range to engage other archer units without taking a few volleys first.
Basically they are only good for fighting factions like undead that that have no ranged units.