Hi and welcome! I'm rather new here too. I'm curious how much outdoor work experience do you have?
I ask this because working 8+ hours day after day outdoors through the seasons is something that requires a fair bit of physical and mental strength. If healthy and positive, I think anyone can adapt to it though

And by adapt I mean finding alternative techniques, altering your pace, or even the time of day or night a task is performed, etc.
But, I have seen a situation where it looked and sounded good to a potential farm worker, but the person ultimately was not comfortable enough to continue working the land...that could be a major deciding factor to consider regarding personal property size, what (if any) farming practices you want to do, terrain like hills, etc...
I think just browsing the permies forums for topics that interest you (and even those that don't) will provide you with a WEALTH of knowledge.
One member I have found especially helpful is Bryant Redhawk, I have been reading some of his information on soil, which is a great place to start learning about permaculture!
I feel like a different person, in the sense that a whole new world has been opened up for me to discover now that I have began to try and understand the Earth and it's inhabitants and elements...I'm sure you share the same feeling
Here's a link to some Redhawk stuff you might like!
https://permies.com/wiki/redhawk-soil