My experience with the .22 Hornet ends with critters the size/weight of coyotes and beaver. That's because it seems fully adequate for beaver, but coyotes, hit thru the ribs and both lungs, seem to run about twice as far as the same shot taken with the marginally more powerful .222 Rem. I have made shots with both cartridges on different coyotes on several occasions and at various moderate ranges and the results seem consistent to me. The Hornet is just about the bottom of the list for me as an "adequate coyote cartridge". I only use one for hunting coyote any more at bush ranges under 100 yards. I would not use a .22 Hornet for deer unless I really needed the meat, as in a survival situation.
Realistically; you and I are used to the longer ranges ( assuming here ) on the Prairie's.
A 40 yd shot isn't inconceivable, just highly rare.
The Hornet is pretty much a brush pusher IMO. Too hard to utilize it on the flat areas.
Skews our POV somewhat