And I've seen videos from Ukraine war where tanks get destroyed by single drone, so it's not that far-fetched.

What I prefer about 1UPT is that it forces you to think more deeply about the location of your battles and the terrain you're fighting in. Moving a large army though a narrow mountain pass, for example, is a lot more difficult, as it should be. I also find it aesthetically better to see big, sprawling battlefields. Looks very epic.

I agree the trade-off is that it can be quite tedious to move large armies a long distance.

To me, the experience of two huge murderballs endlessly chipping away at each other turn after turn has a way of emphasizing the brutality and futility of war. This is lost in Civ 5.