I played Brood War competitively in my younger years. I think RTS is a dying genre. I do agree that the micro/macro aspects of it have been split into separate genres these days.

I also think modern games have good pacing - there are high times and low times for the player to rest and think. In an RTS, the pace speeds up and the game turns into a sprint until it's over. That's really mentally exhausting to play compared to a moba or a round based game like valorant where there are lulls in action where you get to breathe and gather yourself.