Sounds like you are up for complex challenges, but the day-to-day (boring bits) is where you lose interest / fail to keep up with a garden. Same for me, anyway.
The most productive times for me to garden are when I'm procrastinating on boring things for work or household chores
So I do a lot of sporadic, i-get-to-play-outside days, and try to do something useful each time I escape to the garden. I don't mind hard physical work, but I know I'm not good at routine, repetitive tasks.
A book I read recently emphasized that most people are really bad at remembering 'important, but non-urgent' tasks, especially when busy.
A working person with lots of interests will always be busy.
So you can maximize return on effort by investing in clever, self-managing systems; instead of things that depend on your continuing efforts.
One thing I'm finding is that in our high/dry climate, it takes routine water to get perennials established.
Don't be afraid to set up a drip-irrigation timer, or put some extra time into a greywater mulch basin, or set up a hugel bed when you get interested.
Those kinds of things, where you can then 'water' the garden without 'remembering to water the garden', are real lifesavers. In our climate with hard freezes, the irrigation system should be robust enough to handle being accidentally left on, because I do that sort of thing. Or it should automatically turn itself off, and drain, when it detects freezing weather.
So far, I got a cheap hose timer that turns off the hose, and spent a couple spring days last year hauling logs and dirt around to make a hugel. So I can stick the hose in one part of the hugel, go eat or get distracted, and let the timer turn it off. The soaked
wood shares moisture evenly throughout the beds; I don't have to sprinkle each plant.
I am seriously interested in getting an automatic timer that does daily or weekly patterns on multiple hoses, because that would let me get multiple beds and hedges going without changing my habits.
Weeding can happen in bursts, but regular watering is awfully helpful.
I would definitely emphasize perennials and bulbs, things that will keep bearing flowers and fruit year after year. Herbs, too, if your climate will make them perennial.
Annuals are more of an attention hog - going back a week too late and finding your broccoli or radishes have bolted is kinda depressing. But you can look at
local seed-ball varieties, and browse what comes. If you didn't invest a lot of effort then getting anything at all from the garden feels like good luck.
I would also make a point to go for lots of walks and see what's growing for other people. See what's naturally there.
Look for trees that are fruiting in neglected yards in autumn - you don't want to be the guy putting dainty little nets over things, or opening the
greenhouse every morning.
You want to wander through like a bear between hibernation cycles, and eat something tasty, yes?
Or have your friends come over and pick fruit, and bake you a pie as a thank-you.
Maybe you want a yard with just some lovely maple or birch trees, and maybe make some birch beer, and trade it for some produce from people who really like weeding.
How does that sound?
If you don't get this piece of land, I hope you will find the right place.
I've heard of skilled people getting a 'you build it and live in it for X years, I get it afterwards', or even a lifetime lease from local landowners, when they have a good relationship and similar values.
-EKW