That’s more of a question about an individual’s eyesight than a mechanically accurate question. I have poor eyesight and for me, I can reliably hit 9/10x shots within a 6” plate with irons out to 40-60 yds, with a dot out to 60-70yds, and with a scope out to 100-120yds. The biggest thing that affects what distances I’m proficient at for me is actually just lighting conditions and how well I can see the sights and target. What the dot does that improves the experience is allows for a two eyes open shooting which is useful for moving game like feral pigs in timber and it glows which helps me to see the aim point in low light against a dark bodied animal like a black pig or black bear. Technically it also helps increase the rate of fire, but as a hunter that’s irrelevant to me. The downside to running a dot is it adds bulk/complexity which makes it less handy and it requires a different hold which becomes a training issue. None of my carry pieces have an optic for these reasons but I like it on my 480 Ruger which I use as my primary hunting gun for spot and stalk hunting and bear over bait.
I use my scoped 44 as a range toy and very infrequently as a late season hunting option when deer hunting old growth timber after the leaves have fallen, where shots often range in the 70-100yds range as the terrain opens up. Overall it’s my least favorite sighting option for a handgun because the bulk it adds really detracts from the handiness of a handgun which is the point of having a handgun, but it has its place I guess.
My favorite sights for overall/general use and that are on everything I can put them on except these two are the Dawson Precision fiber optic fronts with a black adjustable rear. Nothing fancy but they show up well, carry beautifully, glow for contrast making them easy to pick up, are thinner than the factory front post which makes precision easier to shoot for, are user serviceable for light tubes if they break or you want another color, and are made very very well.