That is the reality someone would face to get into a property like yours. I know from experience a few thousand in a grazing lease and farming doesn’t come close to covering $1M mortgage, insurance, and taxes
The problem we see with the OP is all the stipulations to fit into the budget mentioned…
I get the impression from the OP that he doesn't need the property to produce income in order to purchase it - I agree that would be a whole nuther can of worms and added pressure. I bought my place outright probably 20 years ago so didn't face those kind of issues. Currently there is a very similar place for sale just over the hill from me. (mix of ag acres and native range acres, elk/deer/moose/sharptail/huns/chuks/phez/ruffeds/blues, an established well, good access, backs up to the same 100k+ acres of public land I do) I just did a quick Onx line distance and if I jumped on my horse, crossed onto the adjacent public, and went for a ride, it would be 7 miles, all public, between that parcel and mine. $975K for 307 acres. Other than it does have a power line across it, it really ticks all the OP's boxes - who knows what it will sell for, or if it will sell. Seems overpriced to me. If I sold mine for the same $$/acre, it would be 14x my original purchase price and I would owe a capital gains tax more than twice what I paid for the place. I bought it before I got married so I am still sole owner. When I mysteriously, suddenly, croak my wife will inherit it at a step up in basis. Then she can sell it without significant tax penalty and take her new BF on a lifetime of stone sheep hunts.
I just mentioned that tapping into the income potential of the property can be beneficial. In some cases it can facilitate some of the reasons the place was bought in the first place. In my case, I could just pay the fed/state tax on my rental income and use the balance to go on a pretty decent guided backcountry elk hunt every year...or pay for all my DIY hunting that I do...or whatever. I choose to operate it as a business that sustains itself and puts no burden on my day to day home finances. I get my rent check usually in January whenever they get around to it. Taxes are incredibly minimal...waaay less than my home by factor of near 10. My biggest expense is fuel and equipment costs thru the year as I cut my own hay on the place and maintain a pretty vigilant "security overwatch". Sometimes security involves me getting getting up in the dark, putting a pack on my back, and taking a piece or two of the ranches optical equipment up onto a good glassing point and doing overwatch for, uh, stuff....most commonly in September and October. We just stay there quite a bit that time of year, often with family and friends, in what folks might say resembles "Deer Camp". Sometimes the ranch needs a new "security cam" or two when I find a spot that looks like people or cattle have been coming in off the BLM...funny, it usually turns out to be a herd of elk...only way to know is to put one of the ranches new security cams out there. The business had to get a new pack frame this year to better haul the security equipment up on the hills. It also hauls a T-post driver and a few T-posts really well. By the end of the year my hay operation, general property operation, and "security" expenses have pretty much depleted my yearly rent payment. I just checked - the ranch account has been drained down to $55.26 as of today....just in time to get the rent check next month and repeat. I might owe a smidge of tax on that. I'm a little tongue in cheek on this of course but essentially I'm saying tapping into a properties income potential can, with creativity, offset associated expenses (in my case all of them) as well as help finance the reason/activity you bought the place. YMMV.
Performing surveillance - I had a couple intruders bedded down that we elected to go get a closer look at to determine their intent:
Again, I'll say, personally, I'd probably say it's the best thing I ever purchased in a very rare moment of spontaneity and I'd encourage the OP, with all due diligence, to pursue the dream: