Your soil is the most important factor. pH, soil type, and the depths when layers change will 100% help steer the best tree varieties available to choose. You may have several soil types on your property, and the county should have a soil survey that gives you some indication. The forest service or an arborist can probably help investigate as well.
Then consider specific types, growth speed, resistance to disease, fall colors, cold hours (for fruit bearing trees) and any other ancillary benefits.
I took horticulture in college and almost opened a black walnut tree farm when I was younger, so clearly I am an expert.
Remember that tree trimming is one of the most dangerous occupations in the nation. Workers Comp rates for tree trimmers are among the highest in the nation. We recommend hiring that work out to insured contractors. Falling out of a tree hurt when we were 10. Don’t try it at 50.
Walnuts all over the ground are not something your park landscaper will want to deal with. Trust me.
Also, although my aging parents live in a park with any old enormous trees (which is a reason why they chose that park to buy into), the trees certainly hasten the demise of roofs. A neighbor had a big branch fall through and had to spend $4000 to repair his roof.
Fallen leaves cause mold and rot to roof tops, and also increase groundskeeping labor costs to continually remove seeds, nuts, leaves and debris from roads and property. It’s year round because in spring its seeds, and buds everywhere. Summer it’s storms and falling branches, lightening, etc. Autunm it’s leaves again, and winter, it’s frozen icy branches snapping and causing all kinds of dangers to humans and their homes.
Aesthetically we love trees. Financially they are a pain in the butt. Depending on where you are, consider drought / fire resistant plantings…which will cost more at first but save you money over time. I too have a lot of back education in this subject.