Apple/crab-apples can be pruned to grow pretty flat.

Google "espalier". Depending on the plant species, this can be really easy, or really complex. Keep looking through for the easy possibilities. The fancy word just means an old practice of training certain plants to grow pretty close to, and mostly trained against, a fence or wall.

Thanks, I am familiar with espalier. The only tree that I can think of that is self-fruitful and won't attract yellow jackets around the front door is a persimmon, which isn't foundation-friendly.

Another idea might be a blackberry. You can manage it each year to the shape you want like an espalier tree. I have a thornless Black Satin.

Kumquats? We had one next to the previous house and it was great! No problems at all, except my ex coming over and snaking all the fruit off the thing!!

At that location, maybe Mahonia. i have seen that growing on south walls of buildings in zone 7. The flowers are fragrant, the fruit is edible. They are around 6" tall and I don't know if the landscaping classes there prune them down or not.