I shoot IDPA. I'm 65 (closer to 66), not in good physical condition and a bit overweight. I like to be active at the matches and help keep score and paste, so I'm on my feet the whole match. I have New Balance sneakers. My hips and knees complain during the entire match. Would I be better off with a good hiking boot? And if so, how much do I have to spend? Bass Pro just sent out a flyer with RedHead Wildcat Hikers $49.97 which is $20 off.
Keep in mind I hate for my feet to be hot, but I also hate for my feet to be cold. Is there one type boot good for warm weather with sock fixes for cold weather?
I've found shoes to be vitally important. Needs extreme traction, but often trail running shoes don't have a stiff enough sole. Often ranges use big rock gravel interspersed with fine sand and fine gravel. Some guys wear football or baseball shoes.
So I look for something stiff enough but as light as possible. For me it's critical that the toe box is very wide/roomy and the heel not too tall. I've shot in boots, but prefer the lightest and coolest thing I can find, with a lower heel.
If you go to a USPSA or 3gun match you will see a TON of the Salomon Speedcross. They tick a lot of boxes above. But if I wore them for one day, my feet would pay for months. Way too narrow and tight in the toebox. Toes need room to splay a bit, as our feet are designed to allow this and improper shoe fit can destroy you.
Also: socks. wear a very good quality sock that fits correctly. Cotton tube socks are crap. Good socks help in many ways.
I would also encourage you to look into some info on "zero-drop" shoes. They are shoes that have no heal. @bigfelipe recommended me trying some and I have been using them for everything BUT shooting, but what is happening is I can feel my feet healing and getting stronger. To the point where I can take long walks on very hard surfaces with a 1/8" hard sole thin, flat shoe and feel no soreness. Might be worth looking at.
If it's super cold or wet I wear goretex boots and just accept going slower!