I've never needed to turn a scope down lower than 6X hunting and with custom stocks on my bullpups I can find my target pretty quick at 8 or even 10X. I have wanted to turn it up when a shot requires really good placement. Like the squirrel laying tight to a branch about 60 feet up a large oak Tuesday. Unfortunately I had my Prod which wears a 2-7. I touched it, fur came floating down, but didn't get it. With my bullpups I would have turned the scope up but I've never wanted more than 10X for shot placement on a squirrel. Even a 3-9 should work well for hunting. Certainly a 3-12 is enough.
But target shooting is different for me. I shoot quite a few 30 yard challenge targets which have a 10 ring that is about an eighth of an inch across and an X that is just a dot. I cannot see the targets with the Hawke on my Prod - 7 power is not enough (and it is a $100 scope so the glass isn't great). I can see the target well with my Primary Arms 4-14 but I cannot see the 10 ring or the X dot. But I can still center the reticle on the target and do OK. I shot a 177 with the PA at 14 power. Then I switched the same gun to my Vector 8-32 set at 32 and shot a 185. I think I would have been a few points higher if I'd waited a bit longer for lower wind. The glass in the Vector isn't great and I think I see the target about as well with my Athlon Talos 6-24 and Arken EPL-4 6-24. But I do not see the target as well with any of my other scopes that top out at 16X or less. I shot my one 200 with the Vector set at 32X but I've shot a bunch of 190+ with a different gun using my Athlon Talos 6-24. I am pretty sure the difference is scores is the guns, not the scope. But less than 24X or lesser glass would definitely lower my scores.
I think glass quality is at least as important as magnification to see what we are looking at. To some degree more magnification can make up for lesser glass but it's nice to have both. I like 6-24 for all around scopes on my PCPs but I want SFP so the reticle is visible at 6X.