Only flown through once on the way from ME to Dunundah, and I was time-constrained by an exhibition before I could leave, and a deadline to meet in MEL.
However, if I'd had the time, I'd definitely have spent a day or 2 there to see the city. (no return opportunity as I was doing and RTW, joining my daughter in Oz to fly back to USA with her and then on to family in UK)
Yes, when (if) we can fly ME to Oz in 3 hours, the incentive to "get of this bl00dy aircraft" will no longer be there; but even flying ME to UK, I usually do a stopover, or at least an indirect flight, because (1) I get a chance to visit a new country (2) indirect flights are priced-down to attract customers. (It's more expensive to fly Bahrain-London than to fly Riyadh-Bahrain-London!!)