There is another comment that says this, but for clarity there is a franchise called “Total War” that has multiple editions which is exactly what you are looking for. They also have the ability to control the specific battles on the field like an RTS or you can play it with the battles operating like Civ. I personally really like the Total War Warhammer 3 edition (but I’m a Warhammer fan).

I’m intrigued but I’m super intimidated by the rhythm game sections you show. I don’t want to go full Nigel but can you tell me something that will make me not have a panic attack looking at the huge filled fret board in the trailer?

This is the most nothing title for an article ever. People who have no direct connection think of something but hope something else will happen!