I am on my third pair of regular goretex lined BMW riding boots. These are expensive but IMHO worth every penny. These boots povide great protection and support, and are still comfortable enough to wear while walking for miles. I used to wear mine all day at the office, because I was on concrete floors, with a bad ankle, and needed the support.

Support, protection, and versatility are all important to me in my riding boots.

PS: Your socks are just as important as your boots. I wear a thin wicking liner sock under a regular wool sock. This combination wicks away the moisture, and believe it or not, a thick wool sock insulates well, and can feel more comfortable than thinner synthetics.

PPS: right now I am in Mexico, and it gets hot enough. I walk for 3 -4 hrs on the tricky cobblestone streets, and I sweat everywhere else, but my feet stay cool and dry in my goretex lined boots and thick wool socks.

This advice is based on my personal experience as an infantry soldier, backpacker, and adventure touring m/c rider.
YPMMV
When I toured BAJA for a month, it was hot enough that I stripped off most of my protective gear, and rode with my flip face helmet visor up. But the boots stayed on. Too many cactus and other bad things. One of the other riders rode in open toed sandals. A bolder man.than I.