I'm actually in the process of finally getting exactly this! The USDA Rural Development loan is a pretty solid option for moving out to rural areas and its made specifically to get people to move further out of urban centers. Its 0% down and normally has lower interest rates than conventional loans.

But yeah deadass if you are planning on working in the city, expect long drives and a ton of money burned on gas and repairs. Learning to garden and become self-sustaining isn't super hard as long as you put the effort in to test what your strengths are. Ive spent about 5 years straight of doing test gardens where I planted basically everything I can get my hands on to see what works best for my soil type and in my area.

I remember someone once told me if you're comfortable, you're not growing. Keep searching for ways to make yourself uncomfortable and you'll become comfortable even when poor outcomes happen.